Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server

© Enrico van de Laar 2019

Enrico van de LaarPro SQL Server 2019 Wait Statisticshttps://doi.org/10.1007/978-1-4842-4916-1_3

3. The Query Store

Enrico van de Laar¹ 

(1)

Drachten, The Netherlands

 

With the release of SQL Server 2016, Microsoft introduced an entirely new method to analyze and troubleshoot query performance: the Query Store. The Query Store is often marketed as the “flightrecorder” of SQL Server in that it gives insights into when queries are being executed, how well they performed, and what execution plan was used during execution of the query. While the Query Store did not initially expose wait statistics that were encountered during query execution, the release of SQL Server 2017 included that much awaited addition.

Since the Query Store ...