70-433 · Question #28
You are using SQL Server Profiler to gather deadlock information. You need to capture an XML description of a deadlock. Which event should you use?
The correct answer is C. Deadlock Graph. The Lock:Deadlock event class is produced when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim. Use the Lock:Deadlock event class to monitor when deadlocks occur and which objects are You can use this…
Question
You are using SQL Server Profiler to gather deadlock information. You need to capture an XML description of a deadlock. Which event should you use?
Options
- ALock:Deadlock
- BShowplan XML
- CDeadlock Graph
- DLock:Deadlock Chain
How the community answered
(51 responses)- A2% (1)
- B8% (4)
- C84% (43)
- D6% (3)
Explanation
The Lock:Deadlock event class is produced when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim. Use the Lock:Deadlock event class to monitor when deadlocks occur and which objects are You can use this information to determine if deadlocks are significantly affecting the performance of your application. You can then examine the application code to determine if you can make changes to minimize The Deadlock Graph event class provides an XML description of a deadlock. This class occurs simultaneously with the Lock:Deadlock event class. The Lock:Deadlock Chain event class is produced for each participant in a deadlock.
Topics
Community Discussion
No community discussion yet for this question.