What should you create?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *