Utility Throttles | Teradata Vantage - 17.10 - Utility Throttles - 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)
Utility throttles limit the number of utilities that can run at the same time. A DBA can throttle utility concurrency at two levels.
Throttle Type Utility Concurrency Limit Viewpoint Tab
Utility Limits System-level Sessions
Workload Workload-level Workloads
A utility throttle includes the following values:
  • Utility name
  • Concurrency limit
  • Delay/Reject option

Workload throttles have more qualification criteria, such as Request Source, Target, and Query Band.

TASM does not support the delay option for non-conforming utilities. TASM always rejects non-conforming utilities that exceed throttle limits, even when the throttle specifies Delay.

You might want to create utility throttles for the following reasons:
  • To limit system resource use (for example, CPU, I/O, AMP worker tasks, and memory)
  • To limit how many utilities can run in different system states, such as when the system is very busy