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

The default Workload Method is Timeshare with Medium access rate.

The DBA can select a Top, Medium, High, or Low access rate for the Timeshare workload method.

The DBA has to enter percent share values for the SLG Tier workload method.

Workload Method:

  • Tactical: short queries with a fixed response-time requirement.
  • SLG Tier: important queries that should get extra resources.
  • Timeshare: normal queries. This is the default setting.
  • Tactical exception directive for a WD:

    The Tactical Exception tab is enabled only for the Tactical workload method.

     

    Field/Control

    Action/Comment

    Exception Name

    Enter the name of the tactical exception

    Description

    Specify an optional description

    CPU Time

    Enter the CPU Time value

    Tactical CPU Per Node

    Enter the CPU Per Node value

    IO Physical

    Enter the IO Physical space value

    IO Per Node

    Enter the IO Per Node value