About the SQL Server performance report

SQL Server performance reports can include the following types of data:
  • Dynamic Management View information
  • Query store information
  • Database statistics

SQL Server Dynamic Management View (DMV)

SQL Server provides Dynamic Management Views as a tool to monitor, diagnose, and tune database performance. Each performance report contains DMV information. PolicyCenter automatically generates this type of data and provides the data in each report.

SQL Server Query Store

SQL Server Query Store provides a set of tables separate from the Dynamic Management Views. Query Store persists data to disk, whereas DMV data is in-memory only and lost after a server restart. Thus, it is possible to obtain Query Store database statistics across server restarts.

To include Query Store statistics in the SQL Server performance report, select the Include Query Store Analysis option as you generate the performance report.

If you select the Include Query Store Analysis option, you must also select one or more time intervals for reporting as well:
  • If you select a single time interval, the report contains information for that time interval only.
  • If you select two time intervals, the report contains information from the beginning of the start interval to the end of the last interval and all intervals in between.

The initial page under the Query Store report in the SQL Server Performance report download contains the top SQL queries. The default order sort-order for the SQL queries is time. It is possible to sort the Query Store page using other metrics as well.

For more information on SQL Server Query Store, refer the following web sites:

Database statistics

The performance report can also include the same information as available from the Server Tools Database Statistics report. To include this information in the performance report, select the Include database statistics option as you generate the performance report.