SqlServer 查看死锁信息

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