Category of Work - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
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.