Creating Throttles - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
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.