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_2

2. Overview and Architecture of the Query Store

Tracy Boggiano¹  and Grant Fritchey²

(1)

Cary, NC, USA

(2)

Grafton, MA, USA

 

In order for the Query Store to collect and maintain a baseline on query performance, it needs an architecture that has minimal impact on the overall performance of SQL Server. This chapter will review how Query Store operates to collect data. We’ll also cover the various data sets that make up the Query Store. This information should make it possible for you to both understand what the Query Store is doing and have faith that it’s performing these actions in the safest manner possible for ...