Procedure cache


  •  I need to limit the procedure cache..

    This is what happens -When procedure cache goes above 7.5 GB, it takes long time to search inside the cache for plan and system become slow...

    Once we clear the procedure cache it becomes normal....

    SQL Server 2005 SP3 Enterprise.. on Windows 2008 R2 SP1 Server

    128 GB RAM

    64 Processor ..

    We now have a job to clear procedure cache every 10 minutes to keep it below 7 GB !!!!

    Friday, September 23, 2011 1:37 PM


All replies