17.10 - How Can I Use Throttles to Limit Concurrent Queries to Improve Throughput? - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-2206-101K
Language
English (United States)

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