Throttles and Arrival Rate Meters| SQL Engine 17.10 | Teradata Vantage - Arrival Rate Meters and Throttles - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Release Summary - 17.20 What's New

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-30
dita:mapPath
jva1628096041737.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
weq1472245453190
Product Category
Teradata Vantage

Arrival Rate Meters (ARMs) are TASM rules that provide a way to regulate the flow of requests admitted by TASM into the system. An ARM rule specifies the maximum number of requests per time unit that TASM will admit into the system. Qualification criteria can be used to target specific types of requests.

TASM’s filter and throttle processing sequence for a SQL request is enhanced to check for ARM. New Workload Management ruleset APIs allow you to automate the creation of a system throttle or arrival rate meter without using Viewpoint Workload Designer.

Benefits

  • Prevents a predictable request surge from flooding the TASM delay queue and impacting service time of subsequent queries.
  • Limits resource-intensive requests to a specific rate.
  • Prevents you from submitting many extremely complex queries frequently.

Considerations

  • Use arrival rate meters carefully after an evaluation period in warning mode.

Additional Information

For more information, see Teradata Vantage™ - Application Programming Reference, B035-1090 and Teradata Vantage™ - Workload Management User Guide, B035-1197.