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 |
To View the Blog :http://sqlserverplanet.com/dmv-queries/sql-server-find-resource-currently-involved-in-blocking/
Comments
Post a Comment