Find resource currently involved in blocking

Jan 10, 2014

Lincoln Bovee'

SELECT DISTINCT objname = object_name(p.object_id)
FROM sys.partitions p
JOIN sys.dm_tran_locks t1
ON p.hobt_id = t1.resource_associated_entity_id

SELECT DISTINCT objname = object_name(p.object_id)

FROM sys.partitions p

JOIN sys.dm_tran_locks t1

ON p.hobt_id = t1.resource_associated_entity_id

Views – 1916

LincolnBlog.net