querying a table with xml deadlock graphs

• MissPukeyCow

  Ten Centuries

  Points: 1146

  More actions

  March 31, 2011 at 4:25 pm

  #248956

  Hi there! I have a table of a few months worth of xml deadlock graphs. Would anyone know if it's possible to query the table/xml files to find out which process/login the deadlock victims was?

  Thanks!

• WayneS

  SSC Guru

  Points: 95460

  More actions

  March 31, 2011 at 7:52 pm

  #1306277

  The most recent code for shredding the Deadlock Graph is located here.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• MissPukeyCow

  Ten Centuries

  Points: 1146

  More actions

  April 5, 2011 at 8:37 am

  #1307484

  Awesome script, much appreciated. =)

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 6, 2011 at 1:17 pm

  #1308238

  WayneS (3/31/2011)

  ---

  The most recent code for shredding the Deadlock Graph is located here.

  Looks like an SSC article waiting to happen...

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• MissPukeyCow

  Ten Centuries

  Points: 1146

  More actions

  April 6, 2011 at 5:16 pm

  #1308324

  Article? Yes, please! Seems like there's a lots of information to glean from the shredded xml!