Workload Attributes - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
sef1527114222310.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities
Workload Attributes

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.

Tactical Exception Tab

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