15.10 - Working with Workload Attributes - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

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

After a workload is analyzed, you can view and modify details about the workload, such as workload period and service level goals.

Note: Avoid modifying workload classifications using the following procedure with New Workload Recommendations or Existing Workload Analysis as changes made on the tabbed dialogs will not be reflected in the Workloads Report.

1 From the Candidate Workload Report window, click the + sign to the left of the workload whose attributes you want to view.

The candidate workload listing expands in the tree.

2 Click Attributes.

The Workload Attributes window appears.

3 Click the appropriate tab to view workload attributes, classifications, exceptions, service level goals and query limits as described in Table 17.

 

Tab

Option

Description

Workload Attributes

 

 

 

Name

A name for the new WD. Although not required, typically these begin with the prefix “WD-” for easy identification.

Description

A description identifying this WD.

Log Query Detail

Select this option to specify detailed logging of each query to DBQLogTbl.

Enforcement Priority

  • Tactical - short queries with a fixed response-time requirement.
  • Priority - important queries that should get extra resources.
  • Normal - normal queries; this is the default.
  • Background - low-priority queries with no response-time requirement.
  • Classification

    Criteria #1

    Selects the classification criteria.

    Includes

    Displays the selected objects within the chosen criteria

    Choose

    Allows inclusion and exclusion of strings within the chosen criteria.

    Choose another selection criteria

    Adds another classification criteria, with its own pull-down and object list.

    Accept

    Accepts the changes made to the Classification tab.

    Restore

    Undoes changes to the classification criteria.

    Show

    Creates a report of the classification criteria that maybe saved, printed, or both.

    Exception

    Maximum Rows

    The maximum number of rows in a spool file or final result.

    IO Count

    The maximum number of disk I/Os performed on behalf of the query.

    Spool Size

    The maximum size of a spool file in B.

    Blocked Time

    The length of time the query is blocked by another query.

    Elapsed Time

    The length of time the query has been running.

    Number of Amps

    The number of AMPs that participate in the query.

    Sum Over All Nodes

    The total amount of CPU time (in hundredths of seconds) the query consumes over all nodes.

    Tactical CPU Usage Threshold (per node)

    The per-node threshold of CPU usage for tactical workloads that, when exceeded, triggers exception handling.

    Qualification
    Time

    The length of time the exception condition must persist before an action is triggered (in seconds).

    IO Skew

    Based on the Qualification Time, the maximum difference in disk I/O Counts between the least busy and most busy AMP.

    CPU Skew

    Based on the Qualification Time, the maximum difference in CPU consumption (in seconds) between the least busy and the most busy AMP.

    CPU millisec per IO

    Based on the Qualification time, the maximum ratio of CPU consumption to disk I/O during the last exception interval.

    IO Skew Percent

    Based on the Qualification Time, the percentage difference in disk I/O Counts between the least busy and the most busy AMP.

    CPU Skew Percent

    Based on the Qualification Time, the percentage difference in CPU consumption between the least busy and the most busy AMP.

    Service Level Goals

     

     

    Operating Environment

    Lists the operating environment that the workload is currently in. The default is Always.

    Response Time

    A response-time value in hours, minutes, and seconds. This is the maximum amount of time that you expect to be required for completion of this workload.

    Service Percent

    An integer value corresponding to the percentage of this workload which you expect to meet the service-level criteria.

    Arrival Rate per hour

    An integer value corresponding to the number of queries that you expect to be received hourly.

    Throughput per hour

    An integer value corresponding to the number of queries that you expect to be executed hourly.

    CPU seconds per query

    An integer value corresponding to the processor time (in seconds) that you expect to be required for executing each query.

    Query Limits

    State

    The current state of default or base.

    Override Default

    Select this option to override the default limit for each state specified. When you select this option Unlimited is activated.

    Unlimited

    The default option when Override Default is selected.

    Limit

    Select this option to define a new limit.

    Reject

    Select this option to reject over-limit queries for a particular state, otherwise over-limit queries are delayed.