Post reply

cached execution plan ?

  • August 21, 2012 at 10:20 am

    #280040

    So if i'm in enterprise manager sql server 2008 and i have a stored proc call. for example exec getUsers 'yoyo' and i click show execution plan. Will it show me the cached execution plan if it exists or is it going to generate its own execution plan?

  • August 21, 2012 at 12:16 pm

    #1528302

    is this saying that i'm getting a cache hit? If so then how do i read this. It appears to me it showing a cache miss and a cache hit.

    attaching the output from profiler

  • August 21, 2012 at 12:22 pm

    #1528309

    Cached (providing there is a matching cached plan).

    As for the miss and the hit: http://sqlinthewild.co.za/index.php/2010/07/27/hit-and-miss/

    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

  • August 21, 2012 at 12:30 pm

    #1528314

    are u replying to my first or second comment?

  • August 21, 2012 at 12:32 pm

    #1528316

    Both.

    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

  • August 21, 2012 at 12:38 pm

    #1528325

    darnit!!!

  • August 21, 2012 at 1:04 pm

    #1528342

    If you don't wan the cached plan, then EXEC <procedure> WITH RECOMPILE and get one fresh for your execution that doesn't affect the plan in cache.

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

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