Post reply

SP- executed with more wait time and memory using

  • January 24, 2012 at 2:26 am

    #391384

    Hi,

    I have attached execution plan, could anyone suggestion where is the particular issues?

    Thanks

    ananda

  • January 24, 2012 at 2:29 am

    #1437517

    Procedure text, table definitions and index definitions please.

    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

  • January 24, 2012 at 2:39 am

    #1437526

    please find the procedure and table text

  • January 24, 2012 at 6:09 am

    #1437626

    Index definitions please.

    The first thing you can do for performance is remove those cursors and turn the deletes into a set-based delete. I couldn't see any reason for a cursor.

    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

Viewing 4 posts - 1 through 3 (of 3 total)

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