Developing SQL Databases — Question 165

You suspect deadlocks on a database.
Which two trace flags in the Microsoft SQL Server error log should you locate? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. 1204
• B. 1211
• C. 1222
• D. 2528
• E. 3205

Correct answer: A, C

Explanation

The correct trace flags for identifying deadlocks in SQL Server are 1204 and 1222. Trace flag 1204 provides information about the processes and resources involved in the deadlock, while trace flag 1222 gives a more detailed description of the deadlock graph. Options B, D, and E do not pertain specifically to deadlock reporting.