62,067
社区成员
发帖
与我相关
我的任务
分享
--查询阻塞
SELECT A.request_session_id,
B.blocking_session_id,
B.resource_address,
B.wait_type,
B.wait_duration_ms,
A.resource_associated_entity_id,
A.resource_type,
A.request_type,
D.[text],
G.request_type,
F.[text]
FROM SYS.dm_tran_locks AS A INNER JOIN
SYS.dm_os_waiting_tasks AS B ON A.lock_owner_address=B.resource_address INNER JOIN
SYS.dm_exec_requests AS C ON B.session_id=A.request_session_id CROSS APPLY
SYS.dm_exec_sql_text(C.sql_handle) AS D LEFT JOIN
SYS.dm_exec_requests AS E ON E.session_id=B.blocking_session_id OUTER APPLY
SYS.dm_exec_sql_text(E.sql_handle) AS F LEFT JOIN
SYS.dm_tran_locks AS G ON E.session_id=G.request_session_id