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_5

5. Query Store Catalog Views

Tracy Boggiano¹  and Grant Fritchey²

(1)

Cary, NC, USA

(2)

Grafton, MA, USA

 

Query Store introduces eight new catalog views to SQL Server where it stores all the information you need to query data to troubleshoot SQL Server with Query Store and check the configuration of Query Store. You need VIEW DATABASE STATE permission to query the catalog views. In this chapter you will find descriptions of all the catalog views and their columns then examples of the queries behind the standard Query Store reports we discussed in Chapter 4.

sys.database_query_store_options

The catalog view that holds ...