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