Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

T. LaRock, E. van de LaarPro SQL Server 2022 Wait Statisticshttps://doi.org/10.1007/978-1-4842-8771-2_3

3. The Query Store

Thomas LaRock¹   and Enrico van de Laar²

(1)

East Longmeadow, MA, USA

(2)

Drachten, The Netherlands

 

With the release of SQL Server 2016, Microsoft introduced a new method to analyze and troubleshoot query performance: the Query Store. The Query Store is often called the “flight recorder” of SQL Server because it provides insights into when queries were executed, how well they performed, and the execution plan used during execution. While the Query Store did not initially expose wait statistics, the release of SQL Server 2017 included that ...