Home » Microsoft » 70-762 » Which two trace flags in the Microsoft SQL Server error log should you locate?
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.
A. 1204
B. 1211
C. 1222
D. 2528
E. 3205
Correct Answer: AC
Explanation/Reference:
Trace flag 1204 returns the resources and types of locks participating in a deadlock and also the current command affected.
Trace flag 1222 returns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema.
References: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql?view=sql-server-2017
1204 and 1222