O'Reilly logo

Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries by Grant Fritchey, Tracy Boggiano

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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 Boggiano1  and Grant Fritchey2
(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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required