The Query Store adds a large amount of functionality to SQL Server and Azure SQL Database that helps you in tuning queries. First, the Query Store captures performance metrics on any database that has it enabled, allowing you to look at a historical set of measures. Next, it captures execution plans so that you can see how plans and behaviors change over time. Then, it gives you the ability to control execution plans through a mechanism called plan forcing and another ...
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_66. Using Query Store for Query Performance and Execution Plans
Grant Fritchey1
(1)
Grafton, MA, USA
Get SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
