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

Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.