Viewing Workloads Using the Candidate Workload Report
The Candidate Workload Report window is divided into the following panels:
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 15.00 — SLES11 Support” on page 161. 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.
Figure 2: Candidate Workload Report window displaying unassigned requests
Table 2 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/O’s 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 |