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

Show Hint

Leave a Reply 4

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

Henry Figgins

Henry Figgins

Extended event vs audit vs profiler trace is really a crapshoot if you dont’ see the questions before hand. These tools all do the same thing. They find events and log them into a file or table. Extended the events has the most events predefined. Profiler trace is deprecated and audit has baked events that is a combination of simpler events in extended events. Otherwise they’re the same and you shouldn’t need three different things to do the same thing.

Reply

Henry Figgins

Henry Figgins

Oh, and sql trace does replay on a different server while extended events doesn’t yet…

Reply