~Performance Queries: Pivot View Options~

The Pivot view of a performance query provides a table display summarizing the data for all the requested activities. Each cell in the Pivot represents the combination of the value and the status for a row in the grid view, with the Volume displayed in the cell tooltip. The Pivot view is available for any type of performance query. The table can be sorted according to any column header.

There are status indicator cell background colors for each measurement result cell. The status is color coded as follows:

  • Green: Minor
  • Yellow: Minor
  • Orange: Major
  • Red: Critical

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


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

By default, the Pivot 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.

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.