17.00 - Throttling at the User Level - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K

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).