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
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.
1
0
Oh, and sql trace does replay on a different server while extended events doesn’t yet…
1
0
F
0
1
F
http://www.aiotestking.com/microsoft/what-should-you-create-55/
0
1