Category of Work - 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

Category of Work allocates weight based on importance of the workload; it is best suited for tactical or priority workloads. If Category of Work is selected, Teradata WA assigns AGs, RPs and default weights for each enforcement priority type as shown in the table below. Therefore, it is only required that enforcement priorities are associated to workloads; the RPs and AGs are already set up. (Selecting the Category of Work approach removes any previously defined RPs or AGs.)

Default AG and RP Weights for Priority based on Category of Work
Enforcement Priority AG AG Weight RP RP Weight Global Relative Weight (GRWs)
Tactical Tactical-AG 20 Tactical-RP 60 75%
Priority Priority-AG 40 Standard-RP 20 16%
Normal Normal-AG 20 Standard-RP 20 5%
Background Backgnd-AG 10 Standard-RP 20 2%

When using the Category of Work approach, there are fewer active allocation groups, with those groups having similar relative weights. However, there will be a clear distinction between the Tactical and Priority enforcement priority settings.

Workloads defined with the Tactical or Priority enforcement priority must use the Category of Work approach. They cannot use the Subject Area Resource Division option.