O'Reilly logo

SQL Server 2005 Practical Troubleshooting: The Database Engine by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Procedure Cache Issues

By Bart Duncan

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required