The Veeam Performance Report aggregates historical data and visualizes performance counter values on one or multiple charts and tables. This report extends the functionality of the Microsoft Performance Report available in the Microsoft Generic Report Library. The following table provides a feature comparison for Microsoft and Veeam reports.
Separate series for group average values
Separate series for object average values
Separate series for instance average values
Random line colors on the chart
Details table contains average values for the selected period
Details table contains daily/hourly values for the selected period
A detailed description of advanced Veeam Performance Report features is provided below.
Three Levels of Detail: Group, Object, Instance
For every data series, the Veeam Performance Report can draw separate series within the same series group:
- Group average values — aggregated performance data for the entire scope of the series group.
- Object average values — aggregated performance data for all performance counter instances collected for the same monitoring object.
- Instance average values — aggregated performance data for the same monitoring object and performance counter instance.
To make it easier to read the chart where several series belong to the same series group, the Veeam Performance Report allows using random colors for separate series lines.
Daily/Hourly Values in the Detail Table
The Veeam Performance Report does not require opening miscellaneous sub-reports to view details. The report table contains additional sections that show hourly/daily average values for the collection rule, objects and performance counter instances. By default, these sections are collapsed.
To obtain a detailed performance statistics for specific objects or performance counter instances, you can drill down to the Veeam Performance Details Report directly from the report page, using links in the Rule, Object, Instance column in the table.
This section provides step-by-step instructions that will help you understand how to create the Veeam Performance Report. Consider the following example:
Full transaction logs can make your SQL database unusable. If you have autogrowth disabled, you should proactively monitor free space available in the transaction log files to prevent transaction logs from being completely full and to ensure that your database will continue operating normally.
The Veeam Performance Report can help you analyze the amount of free space in transaction log files. The following example explains how to create a report that shows the transaction log file free space changing over time. Based on this report, you can decide if database recovery model or backup plan should be adjusted or other corrective changes should be applied.
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 Report.
- Choose a data aggregation level.
- Define time intervals.
- Define chart display options.
- Choose values to show on chart.
- Add chart and data series.
- Choose a report scope.
- Choose a collection rule.
- Choose chart style options.
- Run the report.
- View the report output.