Pages

Monday, September 27, 2010

Deadlock Monitoring

DBCC TRACEON(1222,-1). Once you run that in SSMS on that server, the deadlock information will go into the SQL Server Error Log once a deadlock is encountered for all sessions on the server. Then you can read through the events to find out the issues.
Don't forget to set DBCC TRACEOFF(1222), since its an intensive process.