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

Teradata Vantage™ - Advanced SQL Engine Release Summary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
olo1596850177299.ditamap
dita:ditavalPath
olo1596850177299.ditaval
dita:id
B035-1098
Product Category
Software
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.