~Performance Queries: Grid View Options~

The Grid view of a performance query provides a table display in which all requested performance parameters can be viewed simultaneously. This view is available for any type of performance query. The table can be sorted according to any column header, and saved to a .csv format.

The Grid view is a read-only, static table. If filtering is desired, filter parameters are selected (using either the Troubleshoot or Analyze menu), and the grid is then manually regenerated.


When filtering is done using Chart views, the Grid view is not automatically updated.

By default, the Grid view displays no more than 1,000 rows. When a performance query generates over 1,000 results, the system automatically truncates the display to the thousand measurements with the highest values, and a warning message appears to alert the user that results have been truncated. In addition, when a performance query using raw data is generated, the results are automatically limited to 10 End Points, to maintain manageability of the data.

These default settings can be inactivated or updated as required, using the features in the Options menu, which can be accessed using the side menu navigation.

Defining Row Limits and Sorting

This feature enables you to adjust the default maximum number of rows that appear in a grid. In addition, you can specify the types of measurements and performance metrics that are displayed:

  • Limit to Top: The highest measurements are displayed. When Activity Response is measured, End Points with the slowest performance appear.
  • Limit to Bottom: The lowest measurements are displayed. When Activity Response is measured, End Points with the fastest performance appear.
  • Value: The actual numeric values measured, e.g., seconds of Activity Response, percent of CPU usage, etc., are displayed.
  • Volume: The total number of activities or system attributes measured during the selected timeframe are displayed.

Managing Row Count Warnings

This feature allows you to enable and disable the warning displayed when a performance query generates more than a predefined maximum number of results. You can also adjust the default predefined number (1,000).

Setting the Raw Data Query Limit

By default, the results of a performance query involving raw data are automatically limited to 10 End Points. TThis means that any query that uses raw data, and has a potential result of more than 10 unique End Points will result in an error message.

Queries on raw data can create potential performance issues on Aternity FPI, and thus the limitation. The default can be changed to a higher value, but may result in severe performance issues.