• Firstly, if you want a readable deadlock graph, turn traceflag 1204 off and turn traceflag 1222 on (or read the deadlock graph from the system health extended events session)

    The deadlock graph produced by traceflag 1204 is a pain to read and missing important information.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass