I'm trying to figure out what resource the processes are blocking on, but the resource is identified with an "OBJECT: Y:XXXXXXXXX:Z" tag. How can I figure out what it is referring to?
I'm trying to figure out what resource the processes are blocking on, but the resource is identified with an "OBJECT: Y:XXXXXXXXX:Z" tag. How can I figure out what it is referring to?
Hi Gary,
The resource is obtained from wait_resource column of sys.dm_exec_requests. There should be a code after OBJECT referencing the database, object and page. You can try decoding it by using DBCC command or DMVs.
Gita