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_4

4. Standard Query Store Reports

Tracy Boggiano¹  and Grant Fritchey²

(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 ...