Tactical Tier | Teradata Vantage - 17.10 - Tactical Tier - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Advanced SQL Engine
Teradata Workload Management
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

Tactical tier workloads are the first level under the virtual partition in the priority hierarchy. TASM gives this tier all the resources it needs, and the remaining resources are passed down to the next level. Tactical tier is for urgent requests that need results immediately. This tier is optional. Because Tactical tier requests can consume unlimited resources, be careful when assigning workloads there.

Consider the following guidelines when deciding whether to assign a workload to the tactical tier:
  • Assign only workloads that are highly tuned and very short, primarily involving only a few AMPs or one AMP.
  • Do not assign workloads that support load utilities.
  • Monitor exceptions regularly and adjust the exception thresholds as needed.
  • Do not place tactical workloads in virtual partitions with an inadequate resource allocations.