Exam 70-765 topic 3 question 33 discussion

Actual exam question from Microsoft's 70-765

Question #: 33
Topic #: 3

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

Show Suggested Answer

Suggested Answer: D 🗳️
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

by MelKr at April 28, 2020, 4:07 p.m.

Comments

Submit Cancel

MelKr

5 years, 2 months ago

Whenever possible Extended Events should be preferred ove SQL Server Profiler In the default System_Health-session there is already a deadlock detection configured: https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-system-health-session?view=sql-server-ver15

upvoted 2 times

Zikato

4 years, 6 months ago

But you cannot replay them.

upvoted 1 times

...