• shamantha4 - Sunday, June 25, 2017 12:39 AM

    Ed Wagner - Saturday, June 24, 2017 1:33 PM

    Can you post the deadlock graph?

    Hello Ed Wagner,

    We didn't capture deadlock graph,We captured only above deadlock chain.
    By looking at the above Deadlock chain,Could you please suggest me a resolution for this issue.

    We know nothing of the table involved.  Could you at least post the CREATE TABLE statement being sure to include any and all constraints, indexes, and triggers.  I have an idea but it's a total waste of time to bring it up without knowing those things.  I also need to know what the average CPU, Duration, and Logical Reads for that bit of code is and whether or not that bit of code is embedded in an explicit BEGIN TRANSACTION.  It would also be good to know how many rows are currently in the table.

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