15.10 - Viewing Workloads Using the Candidate Workload Report - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

prodname
Teradata Workload Analyzer
vrm_release
15.10
category
User Guide
featnum
B035-2514-035K

The Candidate Workload Report window is divided into the following panels:

  • The right panel displays the Workloads Report. This is a list 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 showing the names of the workloads. After each workload analysis, split, or merge, the workloads redisplay with the evaluation order. See “Viewing Evaluation Order of Candidate Workloads” on page 168 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 15.10 — SLES11 Support” on page 171. 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 7: Candidate Workload Report window displaying unassigned requests

    Table 7 describes the columns in the Candidate Workload report “who” classification.

     

    Table 7: Displayed Columns in the Candidate Workload Report - “who” classifications 

    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