Viewing Workloads Using the Candidate Workload Report
The Candidate Workload Report window displayed in Figure 1 is divided into two panels:
For more information on how to navigate the options in the Candidate Workload report, see “Chapter 4 Analyzing New Workloads to Meet SLGs” on page 35.
Figure 1: Candidate Workload Report for Existing Workloads
Table 1 describes the columns displayed in the Workload report.
|
Column Name |
Description |
|
Workloads |
The name of the workload |
|
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 |
|
SLG Met Details SLG Met, Goal %, Actual %, Remarks |
The number of time the SLG was met for this workload, the goal percentage and actual percentage of SLG met, and comments for this workload |
|
CPU Per Query (Seconds) Min, Avg, StDev, 95th Percentile, Max |
The minimum, average, standard deviation, 95th percentile, and maximum CPU seconds per queries for this workload |
|
Response Time Min, Avg, StDev, Max |
The minimum, average, standard deviation, and maximum result response time for 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 |