How Can I Use Throttles to Limit Concurrent Queries to Improve Throughput? - 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

Queries complete faster when there are fewer running on the system at the same time. Using throttles, you can control the amount of work you allow onto the system, and thereby increase the overall system throughput.

The following are examples of ways you can use throttles to improve the flow of traffic on your system:
  • Limit the number of queries that can run concurrently
  • Limit the number of queries a specific user can run concurrently
  • Limit the number of users that can run queries concurrently

Scenario assumptions

This scenario assumes you already have the following set up:
  • Teradata Database version: 16.00
  • Operating system: SLES 11
  • System: PROD1
  • Ruleset: FILTERS/THROTTLES