当前位置：网站首页>SQL server query database deadlock

SQL server query database deadlock

2022-04-23 10:28:00 【---Pure heart and few desires---】

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 Deadlock

kill id

版权声明
本文为[---Pure heart and few desires---]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204231024447511.html