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_4

4. Standard Query Store Reports

Tracy Boggiano1  and Grant Fritchey2
(1)
Cary, NC, USA
(2)
Grafton, MA, USA
 
SQL Server Management Studio (SSMS) has seven built-in reports for Query Store. These reports give us the ability to quickly view performance data and troubleshoot performance issues in a graphical interface and transition the data into a grid view. In this chapter, we will explore how to interact with these reports and how they complement each other and work together. A list of the reports can be found below the database in Object Explorer as seen in Figure 4-1:
Figure 4-1

Object Explorer view of reports 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