The Candidate Workload Report window is divided into the following panels:
- The right panel displays the Workloads Report.
This is a list of workloads, the percent of the CPU used to process them, average estimated processing time, and the normalized CPU processing time per query.
- The left panel displays the Candidate Workloads tree.
This tree shows the names of the workloads. After each workload analysis, split, or merge, the workloads redisplay with the evaluation order. See Evaluation Order of Candidate Workloads for more information.
All workloads created during analysis are temporary workloads until they are saved to the database.
The maximum number of workloads supported is 250. In SLES 11, default workloads are 5 and the remaining 245 are user-defined. In SLES 10, default workload is 1 and the remaining 249 are user-defined. For more information, see TASM 16.20 — SLES11 Support. Typically the number of workloads will range between 10 and 20 for manageability. On systems with a large number of unassigned requests (accounts or applications, or users), grouping can be used to keep the number of workloads within the supported range.
The following table describes the columns in the Candidate Workload report “who" classification.
Column Name | Description |
---|---|
Account String | The database-related account string for the user |
Percent of Total CPU | Percentage of the total CPU time (in seconds) used on all AMPs by this session |
Percent of Total I/O | Percentage of the total number of logical input/output (reads and writes) issued across all AMPs by this session |
Query Count | The number of queries in this workload that completed during this collection interval |
Avg Est Processing Time | The average estimated processing time for this user |
Normalized CPU Per Query (seconds)
Min, Avg, StDev, 95th Percentile, Max |
The minimum, average, maximum, standard deviation, 95th percentile and maximum expected CPU time for queries in this workload. Normalized CPU per Query (seconds) is the default distribution parameter. |
UnNormalized CPU per Query (seconds)
Min, Avg, StDev, 95th Percentile, Max |
The minimum, average, maximum, standard deviation, 95th percentile and maximum expected UnNormalized CPU time for queries in this workload. |
Response Time (seconds)
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum response time for queries in this workload |
Result Row Count
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum result rows returned for this workload |
Disk I/O Per Query
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum disk I/Os per query for this workload |
CPU To Disk Ratio
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum CPU/Disk ratio for this workload |
Active AMPS
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum number of active AMPs for this workload |
Spool Usage (Bytes)
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum spool usage across all VProcs for this workload |
CPU Skew (Percent)
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum AMP CPU skew for this workload |
I/O Skew (Percent)
Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum of AMP I/O skew for this workload |