Search

Wednesday, July 27, 2011

Start a trace on deadlocks and write it to sqllog

DBCC TRACEON (-1, 1204, 3605)

This means as follows:
(-1 all connections,
1204 deadlock details,
3605 write output of trace flag to SQL error log).

DBCC TRACEOFF(-1, 1204, 3605) turns it off).

No comments:

Post a Comment