输出日志 查日志

DBCC TRACEON (1204, -1)
DBCC TRACEON (1222, -1)

SELECT cntr_value AS NumOfDeadLocks

FROM sys.dm_os_performance_counters

WHERE object_name = 'SQLServer:Locks'

AND counter_name = 'Number of Deadlocks/sec'

AND instance_name = '_Total'

Exec xp_readerrorlog 0