sqlserver检查死锁的sql
select a.spid blocking_spid,a.blocked,c.text blocking_text,d.text blocked_text
from sys.sysprocesses a with(nolock)
left join sys.sysprocesses b with(nolock) on a.blocked=b.spid
cross apply sy
原创
2014-12-31 15:42:54 ·
3559 阅读 ·
0 评论