PrepAway - Latest Free Exam Questions & Answers

Tag: global trace flag

What is the recommended action you should take to start global trace flags?

You manage an instance of SQL Server 2008. You discover some deadlocks on one of the databases stored inthe instance.
You want to start the global trace flag 1204 to obtain information about locks and resourcesparticipating in these deadlocks.
What is the recommended action you should take to start global trace flags?