SELECT 0 ,blocked FROM (SELECT * FROM sys.sysprocesses WHERE blocked>0 ) a WHERE NOT EXISTS(SELECT * FROM (SELECT * FROM sys.sysprocesses WHERE blocked>0 ) b WHERE a.blocked=spid) UNION SELECT spid,blocked FROM sys.sysprocesses WHERE blocked>0 使用查询后的进程ID可以查看死锁元凶的Sql语句和被牺牲Sql语句。 DBCC INPUTBUFFER(82) 附人为制造死锁 BEGIN TRANSACTION SELECT * FROM 表名 WITH (TABLOCKX) WAITFOR DELAY '00:05:00 ' COMMIT TRANSACTION
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。