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
The following is an overview of the process:
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