You administer a Microsoft SQL Server 2012 databasenamed 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