Chapter 4. Procedure Cache Issues
The SQL Server query optimizer grows more intelligent—and more complex—with each release. Query compilation has become more expensive as the query optimizer increases in complexity, and it has become more common to see application workloads that spend a great deal of time in query compilation. The primary purpose of the procedure cache is to cache query plans and allow for their reuse, minimizing compile time and improving the server’s performance. An application that makes efficient use of the procedure cache minimizes both the amount of CPU time spent in unnecessary query compilation and ...
Get SQL Server 2005 Practical Troubleshooting: The Database Engine 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.
