PrepAway - Latest Free Exam Questions & Answers

What should you create?

You administer a Microsoft SQL Server 2012 databasenamed 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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply