16.20 - 16.50 - Creating Throttles - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)
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.