What should you do?
A. Enable trace flag 1222 in the startup options for Microsoft SQL Server.
B. Use the Microsoft SQL Server Profiler Lock:Deadlock event class.
C. Enable trace flag 1224 by using the Database Cpmsistency Checker(BDCC).
D. Create a Microsoft SQL Server Integration Services package that uses sys.dm_tran_locks.
Answer:A
What should you do?
A. Enable trace flag 1222 in the startup options for Microsoft SQL Server. B. Use the Microsoft SQL Server Profiler Lock:Deadlock event class. C. Enable trace flag 1224 by using the Database Cpmsistency Checker(BDCC). D. Create a Microsoft SQL Server Integration Services package that uses sys.dm_tran_locks.
Explanation: When deadlocks occur, trace flag 1204 and trace flag 1222 return information that is captured in the SQL Server error log. Trace flag 1204 reports deadlock information formatted by each node involved in the deadlock. Trace flag 1222 formats deadlock information, first by processes and then by resources.