Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries

© Tracy Boggiano and Grant Fritchey 2019

T. Boggiano, G. FritcheyQuery Store for SQL Server 2019https://doi.org/10.1007/978-1-4842-5004-4_7

7. Forcing Plans

Tracy Boggiano¹  and Grant Fritchey²

(1)

Cary, NC, USA

(2)

Grafton, MA, USA

 

While the information collected in the Query Store and all that it tells you about the performance of your system is the part of Query Store that you’ll use more frequently, the most powerful part of Query Store is the ability to force execution plans. Plan forcing is where the choices made by the optimizer during a compile or recompile event are superceded by a plan you select. Query Store provides enough information between the performance metrics and the execution plan to enable you to decide that, under some circumstances, ...