You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
Company developers are testing a custom application. The developers report that
deadlocks often occur when the application runs a query. The developers have asked you
to help identify which transaction is causing the deadlocks.
How should you troubleshoot the issue?
A.
You should configure a deadlock graph event trace in in SQL Server Profiler.
B.
You should use a dynamic management view querying sys.dm_exec_query_stats.
C.
You should capture deadlock information in an extended events session.
D.
You should use a dynamic management view querying sys.dm_exec_connections.
Explanation: