Home Forums SQL Server 2008 SQL Server 2008 Administration How to find out cause of deadlock? RE: How to find out cause of deadlock?

  • June 12, 2013 at 11:41 am

    #1623450

    That's the reason for my question about how does the OP know if they've had a deadlock. I don't believe they'd be asking if they knew about either TF 1222 or 1205. Some reports of deadlocks do include tracable info and wanted to know where they got the deadlock notification from.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)