16.20.16.20 - 16.20 - Creating Throttles - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
You can use throttles to limit the number of queries running at one time.
  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Throttles.
  3. Next to Throttles, click .
  4. Enter a name.
  5. Create a WHERE clause and select attributes from the list for the workload predicate. When specifying the predicate, you can use existing UDFs, SQL operators, workload management attributes, and AND and OR conjunctions.
  6. Do one of the following to specify a concurrency limit:
    Option Description
    Maximum concurrency Allows the number of concurrent queries you specify to run. Queries submitted after the limit is reached are queued.
    Deny access to new queries Rejects new queries.
  7. Click Save.