Home Forums SQL Server 2008 SQL Server 2008 - General Clearing adhoc plans from the memory CACHESTORE will be useful for the data buffer memory RE: Clearing adhoc plans from the memory CACHESTORE will be useful for the data buffer memory

  • Are you observing any memory pressure ?

    because Clearing the plan cache causes a recompilation of all subsequent execution plans and can cause a sudden, temporary decrease in query performance.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)