Extended Events - Deadlock Graph

  • I know part of it is that I am tired and ready to go get some sleep, but I also believe in NOT recreating the wheel if possible.

    Does anyone have an XSL file that prettifies the deadlock graph returned by the Extended Events? If so, would it be possible to get it?

  • Not an XSL, but it is better than that.

    Here is a deadlock shredder by Wayne Sheffield.

    http://blog.waynesheffield.com/wayne/code-library/deadlocks/shred-deadlock-graph/

    You can take the xml from the graph that is produced by XE and just pass it as a parameter if you like.

    You can also retrieve it directly from the XE session.

    This shredder is highly efficient and will shred those nasty multi-victim deadlocks.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (9/29/2014)


    Not an XSL, but it is better than that.

    Here is a deadlock shredder by Wayne Sheffield.

    http://blog.waynesheffield.com/wayne/code-library/deadlocks/shred-deadlock-graph/

    You can take the xml from the graph that is produced by XE and just pass it as a parameter if you like.

    You can also retrieve it directly from the XE session.

    This shredder is highly efficient and will shred those nasty multi-victim deadlocks.

    Thanks. I will look at when I come back on shift tonight. Right now I need to go get some sleep.

  • 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?

  • I'll ping Wayne and have him respond.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • 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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply