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