Workload metrics are displayed for each workload on the Trends view. Trend intervals and past averages are set in Settings, and metrics are enabled and disabled in Settings.
| Metric | Description | Operating System |
|---|---|---|
| Active Queries | Number of active queries | SLES 10 and 11 |
| Avg CPU-SEC per Query | Average CPU time, in seconds, of all workload queries | SLES 10 and 11 |
| Average Physical KB I/O per Query | Average physical I/O usage, in kilobytes, of all workload queries | SLES 11 |
| Average Response Time and Delay Time | Average response time and delay time for all completed queries | SLES 10 and 11 |
| Cumulative CPU | Cumulative CPU seconds per AMP | SLES 10 and 11 |
| Decayed Active Queries | Total number of queries that have decayed due to CPU or I/O consumption (Timeshare workloads only) | SLES 11 |
| Delayed Queries | Number of queries in the delay queue | SLES 10 and 11 |
| Deferred Queries | Number of queries in deferred queue. | SLES 11 |
| Impact CPU-SEC | Maximum amount of CPU time used by a workload compared to the total CPU used by all workloads on the system | SLES 10 and 11 |
| Max CPU-SEC per Query | Maximum CPU time, in seconds, of all queries that completed | SLES 10 and 11 |
| Maximum Physical KB I/O per Query | Maximum physical I/O usage, in kilobytes, for all queries in this workload | SLES 11 |
| Maximum Response Time | Longest response time of all requests that completed | SLES 10 and 11 |
| Tactical Queries with Exceptions | Total number of queries reassigned to another workload due to CPU or I/O per node tactical exception (Tactical workloads only) | SLES 11 |
| Throughput | Number of queries arriving and completing every minute | SLES 10 and 11 |