sqlserver 锁死情况处理

--1、查找长时间没有反应的操作

SELECT
spid,status,hostname,hostprocess,loginame,program_name,open_tran,b.waittime,cmd
FROM
master.dbo.sysprocesses a with(nolock),
(SELECT blocked,max(waittime) waittime FROM master.dbo.sysprocesses with(nolock)
where blocked>0 AND waittime > 50000  --50000为参数，可自行设置
group by blocked) b
WHERE
a.spid = b.blocked
and a.blocked=0 

--2、kill掉锁死的情况

kill spid        --sqid为参数，即上面查出来的记录的spid