AWT Resource Limits | Teradata Vantage - 17.10 - AWT Resource Limits - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)

The purpose of the AWT resource limit is to prevent utility jobs as a group from using too many AMP Worker Tasks (AWTs) and possibly impacting non-utility work. Users can define their own AWT resource limits or use the TASM defaults. In the Workload Designer portlet, AWT resource limits are in the Throttles view under the Resource Limits tab. The limits are expressed as a percentage of maximum AWTs per AMP.

TASM settings override the DBS Control general fields MaxLoadTasks, MaxLoadAWT, MLOADXUtilityLimits, MaxMLOADXTasks, and MaxMLOADXAWT.