Query Store Catalog Views
Tracy Boggiano, Grant Fritchey · Apress eBooks · 2019
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. In Figure 5-1 you’ll find a relational diagram that shows you how each catalog view is related to each other. You need VIEW DATABSE 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.