Examples: Arrival Rate Meters - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
pzr1600284001549.ditamap
dita:ditavalPath
pzr1600284001549.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage

The following examples show cases in which ARMs are useful:

Problem Solution
Flood of requests from a specific application monopolizes the front of the throttle delay queue. Subsequent requests end up at the end of the delay queue. Create an ARM rule for this application so that other requests can get in between each time unit and can be serviced earlier.
Complex requests use too much resource. Create an ARM rule for complex requests to allow only a few requests each hour during weekdays and a higher limit on weekends.
Certain applications can be extremely resource intensive because they generate a very large number of table scans. Create an ARM rule for table scan requests from the application to spread out the requests over time to reduce peak resource usage by the application.