Home Forums SQLServerCentral.com SQLServerCentral.com Announcements How can i reduce time to generate execution plan and store into cache when Stored procedure execute first time ? RE: How can i reduce time to generate execution plan and store into cache when Stored procedure execute first time ?

  • September 23, 2014 at 2:49 am

    #1747336

    The delay on first execution is unlikely to be the execution plan. Far more likely to be loading the data into cache. Plans just don't usually take that much time to generate.

    You can test it out, on a dev server, using DropCleanBuffers or FreeProcCache to do one of the two, then see where the slow down is actually coming from.

    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