sqlserver查找死锁

概述sqlserver死锁处理 这里要是有master 作为连接对象 select 0 ,blocked from (select * from sysprocesses where blocked>0 ) a where not exists(select * from (select * from sysprocesses where blocked>0 ) b where a.blocked=s

sqlserver死锁处理

这里要是有master 作为连接对象

select 0,blocked from (select * from sysprocesses where blocked>0 ) a where not exists(select * from (select * from sysprocesses where blocked>0 ) b where a.blocked=spID) union select spID,blocked from sysprocesses where blocked>0 删除进程 delete sysprocesses where spID='59' 或者直接 kill 59   总结

以上是内存溢出为你收集整理的sqlserver查找死锁全部内容，希望文章能够帮你解决sqlserver查找死锁所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。