• You should be looking at the section with delete and insert. Two concurrent session got through the delete, may be got page locks due to lock escalation, and both wait for the other to release so that they can proceed with insert.

    Things you may consider,

    1) See the plan for the delete and optimize if necessary

    2) Disable lock escalation

    3) worst case, take a higher lock while delete

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]