Throttling at the User Level - Analytics Database - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage

Use a member rule type system throttle to limit the concurrent requests of users with the same account or profile. This prevents a single user from unfairly dominating a workload, forcing other users to the delay queue.

Teradata recommends that you use a member type system throttle in conjunction with a workload throttle to ensure fairness. For example, create a system member throttle on Profile AcctUsers that is set to 1. Set the workload throttle for AcctUsers profile to 5. Then the AcctUsers workload is allowed 5 concurrent request (due to the workload throttle), but each user mapped to the AcctUsers profile may submit only 1 request (due to the system member throttle).