Skip to content
«
»
 

Find Resource Currently Involved in Blocking

Posted by Derek Dieter
on May 31 2009
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
Filed under DMV QueriesTagged ,
Comment (RSS) |  Permalink

Related Posts:

Ask a question or post a comment

«
»