Replica of Store Procedure taking more time

  • anoop.mehra

    SSC Journeyman

    Points: 94

    Hi All,
    I have optimized one store procedure. Original is taking 35 seconds to take data and new SP is taking more than 1 min.

    So, I tried to make the replica of same SP with the same code, even that is taking more than 1 min.

    Summary is, new replica of same SP is taking also more than 1 min.

    Please suggests, if any one faced this issue. This is very urgent issue.

    Thanks,

  • Eirikur Eiriksson

    SSC Guru

    Points: 182344

    anoop.mehra - Wednesday, April 4, 2018 11:21 PM

    Hi All,
    I have optimized one store procedure. Original is taking 35 seconds to take data and new SP is taking more than 1 min.

    So, I tried to make the replica of same SP with the same code, even that is taking more than 1 min.

    Summary is, new replica of same SP is taking also more than 1 min.

    Please suggests, if any one faced this issue. This is very urgent issue.

    Thanks,

    First of all, don't cross post, doesn't help as now we have no idea which version you are on and posting the same question multiple time tends to get it ignored.
    😎
    Can you post the actual execution plans for both instances of the SP along with full set of relevant information please.

Viewing 2 posts - 1 through 2 (of 2 total)

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