Execution Plan Cache Behavior

  • Grant Fritchey


Once all the processing necessary to generate an execution plan has been completed, it would be crazy for SQL Server to throw away that work and do it all again each time a query gets called. Instead, it saves the plans created in a memory space on the server called the plan cache. This chapter is going to walk through how you can monitor the plan cache in order to see how SQL Server reuses execution plans.



Copyright information

© Grant Fritchey 2014

Authors and Affiliations

  • Grant Fritchey
    • 1
  1. 1.MAUS

Personalised recommendations