SP recompilation

  • We had one procedure suddendly started executing very slow. After recompilation  

    it started working great any idea what might have gone wrong.

    Amit


    Kindest Regards,

    Amit Lohia

  • could be lots of reasons - you really need to try to examine the plan to see what happened. The stock answer is that the underlying data changed sufficiently to cause the plan to be out of sorts OR the parameters that can be passed to the proc are such that the first created plan is not optimal for later queries.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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