The Veeam Performance Details Report aggregates historical data and visualizes performance counter values. This report extends the functionality of the Microsoft Performance Detail Report available in the Microsoft Generic Report Library. The following table provides a feature comparison for Microsoft and Veeam reports.
Details table contains average values for the selected period
Daily/hourly values in the detail table
Separate series for every Object/Group
A detailed description of advanced Veeam Performance Details Report features is provided below.
In addition to the average, minimum/maximum, standard deviation and sample count series, the Veeam Performance Details Report chart also displays a separate series that illustrates the performance trend. The performance trend is based on historical data collected for the reporting time interval.
Performance trend will not be available if you set the Histogram parameter to any other value than No.
Drilling Down to Performance Details
To obtain a detailed performance statistics for specific objects or performance counter instances, you can drill down to data collected for these entities, using links in the Included Objects section.
This section provides step-by-step instructions that will help you understand how to create the Veeam Performance Details Report. Consider the following example:
To ensure that your SQL server can adequately handle all connections, you need to monitor the number of user connections. This will let you trend when your SQL Server is being used more and less during the day, explain spikes in other counters or plan future hardware needs if there is a growing trend.
The Veeam Performance Details Report can help you analyze the number of user connections to the SQL Server. The following example explains how to create a report showing how the number of user connections changes during the day.
To follow the usage instructions, you must have the SQL Server Monitoring Management Pack installed.
To create the report, follow these steps:
- Open the Veeam Performance Details Report.
- Choose a data aggregation level.
- Define time intervals.
- Choose a histogram type.
- Add data series.
- Choose a report scope.
- Choose a collection rule.
- Run the report.
- View the report output.