nerdexam
Microsoft

70-451 · Question #140

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. See the full explanation below for the reasoning.

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

(31 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    84% (26)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice