--- title: "Veeam Performance Top (Bottom) N Report" description: "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." canonical: "https://helpcenter.veeam.com/docs/mp/reports/veeam_performance_top_n_report.html" breadcrumb: "Veeam MP Report Knowledge > Veeam Report Library > Veeam Performance Top (Bottom) N Report" dateModified: "2026-09-10" --- # Veeam Performance Top (Bottom) N Report 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. ## Description 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. ## Parameters Date/time Selection: defines the time period to analyze in the report. Algorithm: defines whether top or bottom performing objects and performance counter instances will be displayed in the report. Count: defines the number of top or bottom objects and 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. ## Sample Usage Report on the 10 SQL databases that have the least amount of free space left in your infrastructure during this week. ::: note To follow the instructions, you must have the SQL Server Monitoring Management Pack installed. ::: **Instructions** 1. Open the Veeam Performance Top (Bottom) N Report. 2. From the **From** list, select *This Week* > *Monday*. From the **To** list, select *This Week* > *Friday*. 3. From the **Algorithm** list, select *Bottom*. 4. In the **Count** field, enter *10*. 5. From the **Sort Function** list, select *Min* to range report results starting from the least value. 6. From the **Group by** list, select *Object*. 7. In the **Fields to Show** list, select all options. 8. 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, enter *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**. 9. In the **Performance Rule** section, click **Browse**. In the **Select rule** window, open the **Search By Counter** tab; from the **Performance object** list, select *SQLSERVER : Database* and click **Search**. In the **Available items** list, select the *Collect Database Total Free Space (%)* rule and click **OK**. 10. Click **Run** to view the report. **Report Output** 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. ::: note 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](veeam_performance_details_report.md).