Workload metric descriptions for the trends sparkline graphs shown in the Workloads details view are listed below.
Metric | Description | Operating System |
---|---|---|
Avg CPU-SEC per Query | Average CPU time, in seconds, of all workload queries | SLES 10 and 11 |
Max CPU-SEC per Query | Maximum CPU time, in seconds, of all queries that completed | SLES 10 and 11 |
Cumulative CPU | Cumulative CPU seconds per AMP | SLES 10 |
Average Physical KB I/O per Query | Average physical I/O usage, in kilobytes, of all workload queries | SLES 11 |
Throughput | Number of queries arriving and completing every minute | SLES 10 and 11 |
Active Queries | Number of active queries | SLES 10 and 11 |
Delayed Queries | Number of queries in the delay queue | SLES 10 and 11 |
Average Response Time & Delay Time | Average response time and delay time for all completed queries | SLES 10 and 11 |
Maximum Response Time | Longest response time of all requests that completed | SLES 10 and 11 |