Viewing Workloads Using the Candidate Workload Report - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
Product Category
Teradata Tools and Utilities

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.

Candidate Workload Report Window Displaying Unassigned Requests

The following table describes the columns in the Candidate Workload report “who" classification.

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/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