© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_26

26. Plan Caching

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Query optimization is a resource-intensive process that could introduce a significant CPU load on busy servers. SQL Server tries to minimize such load by caching plans in a special part of the process memory called the plan cache.

This chapter talks about plan caching in detail and consists of two parts. The first part provides a high-level overview of plan caching and discusses several issues associated with it. The second part dives deeper into plan cache internals and discusses the various data management views (DMVs) that you can use for plan cache monitoring.

Plan Caching Overview ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.