Query Store reports in SQL Server Management Studio

In the previous section, you saw that migration to SQL Server 2017 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 a 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 the most server resources, you can use Query Store reports.

When Query Store is enabled for a database, in the Object Explorer of the SSMS you can find a new node called Query Store for this ...

Get SQL Server 2017 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.