How Can I Use Throttles to Limit Concurrent Queries to Improve Throughput?

Teradata Viewpoint User Guide

prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K

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: 15.0
  • Operating system: SLES 11
  • System: PROD1
  • Ruleset: FILTERS/THROTTLES