{"id":77,"date":"2009-05-31T23:38:35","date_gmt":"2009-06-01T06:38:35","guid":{"rendered":"https:\/\/sqlserverplanet.com\/?p=77"},"modified":"2009-05-31T23:38:35","modified_gmt":"2009-06-01T06:38:35","slug":"sql-server-find-resource-currently-involved-in-blocking","status":"publish","type":"post","link":"https:\/\/sqlserverplanet.com\/dmvs\/sql-server-find-resource-currently-involved-in-blocking","title":{"rendered":"Find Resource Currently Involved in Blocking"},"content":{"rendered":"<p>[cc lang=&#8221;sql&#8221;]<br \/>\nSELECT DISTINCT<br \/>\n\tobjname = object_name(p.object_id)<br \/>\nFROM sys.partitions p<br \/>\nJOIN sys.dm_tran_locks t1<br \/>\nON p.hobt_id = t1.resource_associated_entity_id<br \/>\n[\/cc]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[cc lang=&#8221;sql&#8221;] 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 [\/cc]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"","footnotes":""},"categories":[9],"tags":[38,49],"class_list":["post-77","post","type-post","status-publish","format-standard","hentry","category-dmvs","tag-blocking","tag-dmv"],"_links":{"self":[{"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/posts\/77","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/comments?post=77"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/posts\/77\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/media?parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/categories?post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverplanet.com\/wp-json\/wp\/v2\/tags?post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}