The Overall Resource Consumption report can be used to determine the impact of particular queries on all database resources. The report has predefined panes where you can see the impact of queries for overall duration, execution count, CPU time, and logical reads. You can define an additional three parameters (logical writes, memory consumption, and physical reads) and you can also show this info in a grid format. A common report with default windows is shown in the following screenshot:
Overall Resource Consumption report
This Query Store report will not find plan regressions, but can help you to quickly ...
