Query Store reports in SQL Server management studio
In the previous section, you saw that migration to SQL Server 2016 can lead to performance regressions for some database queries. In this example, you had only one query and since the regression was significant, you could immediately detect it; you did not need help from Query Store. However, in the production system, you could have hundreds or thousands of queries, and you will not be able to check them to see if they perform well after migration. To find regressed queries or queries that are consuming most server resources, you can use the Query Store reports.
When Query Store is enabled for a database, in the Object Explorer of the SQL Server management studio you can find a new node Query Store for this database. When you expand the node, you can find four reports under it:
- Regressed queries
- Top resource consuming queries
- Overall resource consumption
- Tracked queries
You have already seen the report Tracked Queries in action; here we will...
