1.直接查看死锁语句
sp_lock
sp_who
sp_who2 54
dbcc inputbuffer(54) --查看具体死锁语句
2.开启数据库死锁跟踪,在sqlserver日志中查看
--启用跟踪
dbcc traceon(1204,1222,3605,-1)
--关闭跟踪
dbcc traceoff(1204,1222,3605,-1)
1.直接查看死锁语句
sp_lock
sp_who
sp_who2 54
dbcc inputbuffer(54) --查看具体死锁语句
2.开启数据库死锁跟踪,在sqlserver日志中查看
--启用跟踪
dbcc traceon(1204,1222,3605,-1)
--关闭跟踪
dbcc traceoff(1204,1222,3605,-1)