Question about column resource_description is sys.dm_os_waiting_tasks DMV

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  March 2, 2015 at 4:32 am

  #294947

  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/