Tactical Tier | Teradata Vantage - 17.00 - Tactical Tier - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K

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.