Key Wait Resource
Below is a sample of blocked process report with Key as wait resource .
The first part of the key wait resource is the database id and second part is called as Hobt_Id. Hobt is an acronym for Heap Or B Tree. The hobt_id can be mapped to sys.indexes and sys.objects through sys.partitions. Below script will map the key wait resource to corresponding index and table.
SELECT o.name AS TableName, i.name AS IndexName,SCHEMA_NAME(o.schema_id) AS SchemaNameFROM sys.partitions p JOIN sys.objects o ON p.OBJECT_ID = o.OBJECT_ID JOIN sys.indexes i ON p.OBJECT_ID = i.OBJECT_ID AND p.index_id = i.index_id WHERE p.hobt_id = 72057594040811520
Page Wait Resource
Below is a sample of blocked process report with Page as wait resource .
As everyone knows, the first part of the wait resource is the database id (68) , second part is file id (1) and third part is the page number(492478). To find out the object id associated with this page follow the below steps.
SELECT DB_NAME(68)
GODBCC page (68, 1, 492478) --Database_id,file_id,page_id
This will give a result as given below.
The object id can be mapped to a table using the system function object_name()
Object Wait Resource
