Capture Deadlock Graph using Profiler

To Capture a Deadlock Graph using Profiler (NB: with SQL 2008 and above you can also use an extended-event).

• File / New trace
• Connection details
• Use Template / Blank
• Events Selection / Locks ..1) DeadlockGraph 2) Lock:Deadlock 3) Lock:Deadlock Chain
• Event Extraction Settings / Save Deadlock XML events seperately / (somefilename)
• Each deadlock in a distinct file
• All Deadlocks
• Run
• (wait)
• File / Export / Extract SQL Server Events / Extract deadlock Events / (somefilename2)