当前位置：网站首页>SQLServer 查询数据库死锁

SQLServer 查询数据库死锁

2022-04-23 10:24:00 【---清心寡欲---】

SELECT der.session_id, der.start_time, datediff(ms,der.start_time,getdate()) as ms, der.cpu_time as cputime, der.logical_reads,
dest.[text] AS 'sqlcmd', der.*
FROM sys.[dm_exec_requests] AS der
CROSS APPLY
sys.[dm_exec_sql_text](der.[sql_handle]) AS dest
WHERE [session_id]>50 and [database_id]=db_id()
ORDER BY der.session_id DESC

kill死锁

kill id

版权声明
本文为[---清心寡欲---]所创，转载请带上原文链接，感谢
https://blog.csdn.net/ying456baby/article/details/119829342