The Plan Cache
It’s important to understand that the plan cache in SQL Server 2005 is not actually a separate area of memory. Releases prior to SQL Server 7 had two effective configuration values to control the size of the plan cache, which was then called the procedure cache. One specified a fixed size for SQL Server’s total usable memory; the other specified a percentage of that memory (after fixed needs were satisfied) to be used exclusively for storing procedure plans. Also, in releases prior to SQL Server 7, query plans for adhoc SQL statements were never stored in the cache, only the plans for stored procedures. That is why it was called procedure cache in older versions. In SQL Server 2005, the total size of memory is by default dynamic, ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
