Query Session Throttles | Teradata Vantage - 17.10 - Query Session Throttles - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)

The Query Sessions throttle limits the non-utility sessions that can log on at the same time. The Query Sessions throttle can only reject sessions trying to log on; it cannot delay session logons. Once TASM rejects a throttled session, the user has to log on again.

The Query Sessions throttle can use only source classification criteria. For example, it can include account names, profiles, or IP addresses. It may not include target criteria, such as a database name or table name.

Choose from the following four Rule Type options when you create a Query Sessions throttle:
Arrival Rate Monitor
Defines an admission limit as a rate that is an integer per time unit (for example, 10 requests/minute), instead of a simple integer. Each incoming SQL request is checked against arrival rate monitor (ARM) rules before throttle rules. When an applicable ARM limit is reached, the incoming request is deferred in a new queue, called the Defer. When the deferred request is released from the Defer queue (or admitted by TASM), it is checked against applicable throttle rules.
DIPTDWM must be run to create or migrate TDWM tables for ARM support.
Collective
Provides the least granular control. TASM treats all requests that qualify for this throttle as one group. If the requests are delayed, the delay is based on the concurrency level of the entire group. For example, users Jay, Kay, and May are the classification criteria for a system throttle rule with a limit of 3 requests. With the collective option, all the users together cannot have more than 3 requests running at the same time.
Individual
Each individual object that is associated with the throttle is treated independently of other, similar objects. Each object has a counter. For example, if users Jay, Kay, and May are the classification for a throttle rule with a limit of 3 requests, each of the users can have up to 3 requests running at the same time.
Member
Provides the most fine control. TASM treats each user in a throttled object (such as account) independently of other users in that account. The intent of the Member option is to enable objects that represent groups of users, such as accounts and profiles, to be used as the classification criteria for the rule. The rule specifies the group, and any member of the group is covered by the rule. For example, users Jay, Kay, and May are associated with account ShoeDept. If there is a system throttle rule with a session limit of 3, classification criteria of account ShoeDept, and the Member option, then each of the users with the ShoeDept account can have up to 3 requests running at the same time.