查找sqlserver查询死锁源头的方法 sqlserver死锁监控

查找出SQLServer的死锁和阻塞的源头 –查找出SQLServer死锁和阻塞的源头 代码如下:use mastergodeclare @spid int,@bl intDECLARE s_cur CURSOR FORselect  0 ,blockedfrom (select * from sysprocesses where  blocked>0 ) awhere not exists(select * from (select * from sysprocesses where  blocked>0 ) bwhere a.blocked=spid)union select spid,