You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.
You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording
events and playing them back on a different test server.
What should you create?
A.
A Database Audit Specification
B.
A Policy
C.
An Alert
D.
A SQL Profiler Trace
E.
A Resource Pool
F.
An Extended Event session
G.
A Server Audit Specification
Explanation:
Use SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic
dependency between two or more threads, or processes, for some set of resources within SQL Server. Using
SQL Server Profiler, you can create a trace that records, replays, and displays deadlock events for analysis.
http://msdn.microsoft.com/en-us/library/ms188246.aspx