Throttles - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem

A throttle limits the number of queries running at one time on an Aster system.

You specify the predicate when you create the throttle and it must be a valid SQL WHERE clause. You can use existing UDFs, SQL operators, workload management attributes, and AND and OR conjunctions.

You set a concurrency limit by specifying the maximum number of queries matching the predicate that can run at a given moment. Each query must pass all predicates before being admitted to the system. Queries submitted after the limit is reached are queued. Throttles are known as admission limits in the Teradata Aster® Database User Guide.

You can create a throttle to limit queries based on:
  • A specific database to which the client is connected.
  • A set of database roles of which the current user is a member, such as users who have been granted the admin role.
  • A statement type, such as SELECT, DROP, EXPLAIN, REVOKE, SHOW, and others.
  • Elapsed time, such as limiting a specific statement that has executed over 30 minutes by a user that is part of a group.

Global throttles limit the maximum number of concurrent queries to a value you specify regardless of the attributes of the queries. If the number of running queries reaches the value you set, new queries are queued. If the global throttle limit is not reached, the regular throttles setting determines if and when a query is admitted to the system. Global throttles are known as global admission thresholds in the Teradata Aster® Database User Guide.