Post reply

query plan(s)

  • November 1, 2012 at 11:08 am

    #264977

    Hi all,

    I have a job that took a pretty long time last night compare to a day ago. It was hours vs minutes.

    I wonder how I can find out what went wrong. Is there a view/table I can access to compare execution plans for the past 2 days?

    Thanks,

    Eugene

  • November 1, 2012 at 11:29 am

    #1555121

    Disregard

  • November 1, 2012 at 12:05 pm

    #1555133

    No. What's in the plan cache now is the only plan you can see unless you set up some form of tracing to capture plans.

    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 3 posts - 1 through 2 (of 2 total)

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