Post reply

Details from sys.dm_tran_locks DMV

  • November 23, 2010 at 2:00 am

    #229034

    Hi All,

    Was doing some monitoring on a SQL Server 2008 RTM enviroment and when querying the sys.dm_tran_locks dmv I came across a number of request_owner_guid with a value of 00000000-0000-0000-0000-000000000000.

    I can see that they are all SHARED_TRANSACTION_WORKSPACE and are locks on a particular database. This 1 database has 7 of these locks. I'm looking for more information on these entries. What are they...where are they from. Is this something to be conncerned about.

    There's no performance issues on this server...but still would like to find out what there are about

    I don't see them on my other servers..therefore the questions.

    Thanks

    Denesh

  • November 23, 2010 at 3:49 am

    #1254293

    Hi Denesh!

    There is a DATABASE shared lock on a database for every connection. You can test this by open some query windows to a certain database in Management Studio and execute:

    select DB_NAME(resource_database_id),* from sys.dm_tran_locks

    where request_owner_guid = '00000000-0000-0000-0000-000000000000'

    You can see that there are as many rows for the database as you have connections (provided you are the only user).

    The engine uses this information to check if there are any active connections to a database.

    Cheers

  • November 23, 2010 at 5:24 am

    #1254361

    Hi Brigadur

    Thank you for the reply

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply