March 2, 2015 at 4:32 am
Hi all
I have a question about column resource_description in sys.dm_os_waiting_tasks. Below is an example of the value of column resource_description for a process that is waiting for an exclusive lock on a row:
keylock hobtid=72057595465433088 dbid=5 id=lock2403057280 mode=X associatedObjectId=72057595465433088
From what I understand, the string says that the resource is an exclusive lock on a specific key at a table that it's hobt_id in sys.partitions is 72057595465433088. This table exists in a database that has the ID 5. What I don't understand is this part - "id=lock2403057280". What is this number stands for? What is the information that I can get from it?
Thank you for your replies.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply