Category of Work - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

Category of Work

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 Table 7. 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.)

 

Table 7: 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.