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.

References: http://msdn.microsoft.com/en-us/library/ms188246.aspx