Sql 死锁 杀死死锁进程



1. 询所有的死锁进程。语法如下：

-- **** 查询进程死锁 ****
-- **********************
-- **********************

SELECT TOP 10
  [session_id],
  [request_id],
  [start_time] AS '开始时间',
  [status] AS '状态',
  [command] AS '命令',
  dest.[text] AS 'sql语句',
  DB_NAME([database_id]) AS '数据库名',
 [blocking_session_id] AS '正在阻塞其他会话的会话ID',
 [wait_type] AS '等待资源类型',
 [wait_time] AS '等待时间',
 [wait_resource] AS '等待的资源',
 [reads] AS '物理读次数',
 [writes] AS '写次数',
 [logical_reads] AS '逻辑读次数',
 [row_count] AS '返回结果行数'
 FROM sys.[dm_exec_requests] AS der
 CROSS APPLY
 sys.[dm_exec_sql_text](der.[sql_handle]) AS dest
 WHERE [session_id]>50 AND DB_NAME(der.[database_id])='FlexSFS' 
 ORDER BY [cpu_time] DESC

2.查询出来结果之后，就要杀死相应的死锁进程。加入上面结果中有个死锁的SessionId为76

则

kill 76

3. 再查询1里面的死锁进程，就会发现没有死锁进程了。