Home Forums SQL Server 2008 SQL Server 2008 - General Extended Events - Deadlock Graph RE: Extended Events - Deadlock Graph

  • September 30, 2014 at 1:54 pm

    #1749256

    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...

    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