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.
An Extended Event session
B.
A Policy
C.
A Database Audit Specification
D.
An Alert
E.
A Server Audit Specification
F.
A SQL Profiler Trace
G.
A Resource Pool
Explanation:
http://msdn.microsoft.com/en-us/library/ms188246.aspx