Lynn Pettis (9/30/2014)
Well, it works great, now I just need to figure out what it is telling me.
I am curious about part of it. The QueryStatement column is blank in all the rows, but there appears to be a sqlhandle in the XML data. XML isn't my strong suit, any way to add the extraction of the handle?
Lynn - any chance that you can email me the deadlock graph so that I can look at it? I wouldn't post it... too much info hidden in there, and I know where you work...
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
, How to ask a question
, Performance Problems
, Common date/time routines
,CROSS-TABS and PIVOT tables Part 1
& Part 2
, Using APPLY Part 1
& Part 2
, Splitting Delimited Strings