Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning find out which queries are causing the deadlock RE: find out which queries are causing the deadlock
Michael Valentine Jones
SSC Guru
Points: 64818
More actions
May 5, 2014 at 8:41 am
#1710732
This will log deadlock info to the SQL Server error log:
print 'Set on Trace Flag 1222 to log deadlocks'
dbcc traceon(1222,-1)
print 'Show all trace flags that are on'
dbcc tracestatus(-1) with no_infomsgs