PrepAway - Latest Free Exam Questions & Answers

Tag: sql server trace flags

Which trace flag should you use?

You are responsible for managing an instance of SQL Server 2008. You discover that the server is performingvery poorly.
You investigate and discover that deadlocks are causing the problem. You want to identify which processes and resources are causing the problem.
You want to ensure that theinformation you receive about deadlocks is formatted by processes and then by resources. Which trace flag should you use?