Post reply

Plan reuse. How to find it out?

  • December 26, 2017 at 1:10 pm

    #341415

    Hi All,

    How can I tell/prove, whenever I run a stored proc or an ad-hoc sql statement in SSMS query window, whether SQL has reused the plan from plan-cache or a new plan got generated. Can this info be obtained from actual execution or is there an alternative way to find this information out?

    Thanks,

    Sam

  • December 28, 2017 at 4:14 am

    #1973688

    https://www.sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/

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

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