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

Teradata Vantageā„¢ - Workload Management User Guide

Advanced SQL Engine
Teradata Workload Management
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

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.