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

  Discussion forum


Leave an answer