This report aggregates historical performance data and shows top or bottom N infrastructure objects, performance counter instances or both for a specific performance counter across a time range.
The Veeam Top (Bottom) N Contained Objects or Instances Report extends the functionality of the Microsoft Generic Report library by adding the following advanced features:
- Scope selection: you can run the report for any set of objects in the managed environment.If there are several performance counter instances, you can choose to build the report for selected performance counter instances or use all of them.
- Grouping and sorting options: the report offers advanced grouping and sorting options. You can group report records by objects, performance counter instances or objects and instances. You can sort results on the report chart and in the detail table by the aggregate function.
- Data aggregation: the report offers hourly and daily levels of data aggregation. Data aggregation levels depend on the length of the selected time interval.
Date/time Selection: defines the time period to analyze in the report.
Algorithm: defines whether top or bottom performing objects and/or performance counter instances will be displayed in the report.
Count: defines the number of top or bottom objects and/or performance counter instances that will be included in the report. The value can range between 1 and 200.
Sort Function: defines the aggregation function that will be used to sort report results on the chart and in the detail table (Avg, Min, Max or Sum).
Group by: defines how data will be grouped in the report (by Object, Counter Instance or Object and Counter Instance).
Fields to Show: defines what fields will be shown in the Object column of the report table (object type, path, name).
Scope: defines a list of Groups or Objects to analyze in the report. The Add Group option returns a Group and all objects that a group contains (with all performance counter instances). The Add Object option returns only the selected object.
Performance Rule Selection: defines a collection rule for a performance counter to analyze in the report.
All instances/Specific instances: defines whether all or specific instances of a class at which the rule is targeted will be analyzed in the report.
Report on the 10 SQL databases that have the least amount of free space left in your infrastructure during this week.
To follow the usage instructions, you must have the SQL Server Monitoring Management Pack installed.
- Open the Veeam Performance Top (Bottom) N Report.
- From the From list, choose This Week > Monday. From the To list, choose This Week > Friday.
- From the Algorithm list, choose Bottom.
- In the Count field, type 10.
- From the Sort Function list, choose Min to range report results starting from the least value.
- From the Group by list, choose Object.
- In the Fields to Show list, select all options.
- In the Scope section, include the necessary databases in the report.
Click Add Object. In the Add Object window, click Options. In the Options window, click Add. In the Class Name search box, type “sql database” and click Search. Select the SQL Database class in the list of search results, click Add and click OK. In the Options windows, click OK to apply the filter. In the Add Object window, click Search. The search will return a list of objects that belong to the SQL Database class. Select all databases in the list, click Add and click OK.
- In the Performance Rule section, click Browse. In the Select rule window, open the Search By Counter tab; from the Performance object list, choose SQLSERVER : Database and click Search. In the Available items list, choose the Collect Database Total Free Space (%) rule and click OK.
- Click Run to view the report.
The report will show performance data for the 10 SQL databases that have the least amount of space left.
The chart will display the following details for every database: average amount of available space and the minimum-to-maximum value range for the selected period.
The table will display additional details for every database: database name, sample count, minimum, maximum and average space values, and standard deviation.
If several objects have the same ranking function value, the report will include more objects than you have set in the Count field. For example, the “bottom 10” report will show 11 objects if two objects “share” the same position (have the same value).
You can click database names in the output table to drill down to the Veeam Performance Details Report.