![]() ![]() INNER JOIN sys.partitions AS p ON p.hobt_id = tl.resource_associated_entity_id INNER JOIN sys.dm_os_waiting_tasks AS wt ON tl.lock_owner_address = wt.resource_address INNER JOIN sys.databases db ON db.database_id = tl.resource_database_id OBJECT_NAME(p.OBJECT_ID) BlockedObjectName, Script used to identify the blocking query SELECT
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |