O'Reilly logo

SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance by Grant Fritchey

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

© Grant Fritchey 2018
Grant FritcheySQL Server 2017 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-3888-2_16

16. Execution Plan Cache Behavior

Grant Fritchey1 
(1)
Grafton, Massachusetts, USA
 

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 will walk through how you can monitor the plan cache to see how SQL Server reuses execution plans.

In this chapter, I cover the following topics:
  • How to analyze execution plan caching

  • Query plan hash and query hash as mechanisms for identifying queries to tune ...

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