Top resource – consuming queries

The Top resource consuming queries report shows you the most expensive queries (25), based on your chosen metric, analogous to the previous report type. The displayed panes are the same as in the regressed queries report. The only difference between them is extracted queries: top resource consumers can also see queries that did not regress, but just use a lot of server resources. A sample report is shown in the following screenshot:

Top resource-consuming queries report

This Query Store report will not find plan regressions, but can help you to quickly identify the most expensive queries in a database in a ...

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.