Take the 2-minute tour ×

In the question Need Help Troubleshooting Sql Server 2005 Deadlock Scenario there was a suggestion of using DBCC TRACEON (1204, -1) to trace deadlocks globally.

When reading about this command in BOL it states that it should only be used while users or applications are not concurrently running statements on the system. Does it mean that we must be in singleuser-mode when enabling this trace-flag? And in addition, why is it required and is it important to follow the advice? (Just seems a bit hard to follow in a production system that is always running.)

share|improve this question

1 Answer 1

up vote 4 down vote accepted

This applies more to other trace flags (eg 610 for minimal logging) that affect the optimiser and important behaviours/optimisations

You should be OK with the deadlock trace flags 1204, 1205 and 1222

share|improve this answer

Your Answer


