Overall Resource Consumption report

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 identify the most expensive queries in a database in a given time interval.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.147.62.94