What Is an Enforcement Priority? - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
When a workload is created in SLES 10, it is assigned an enforcement priority (EP) and an allocation group (AG). An EP is a label given to assign weights for the queries running in a workload. Each AG takes the EP of the first workload associated with it and after that, only workloads with the same EP can be associated to that AG. As a result, each AG is a collection of one or more workloads that share the same EP. Multiple AGs can use the same EP. Analytics Database uses the following EPs:
  • Tactical queries are short, critical queries with defined service level goals. They are typically single or few-AMP queries or all-AMP queries that consume less than 1 CPU-second per node.
  • Priority queries are important and have higher priority than most other work.
  • Normal queries are the average priority work running on the system.
  • Background queries run for work that does not have a response-time requirement.