When Workload Throttles Prevent Full Resource Usage - Advanced SQL Engine - Teradata Workload Management

Workload throttles limit the number of requests that can run concurrently in a workload to prevent overutilization of system resources. However, in some cases, workload throttles can prevent full resource utilization. The Enable Flex Throttles option, available for SLES 11 systems with TASM for Enterprise Data Warehouse platforms, can detect situations in which workload throttle limits are preventing full resource utilization, and release work from the delay queue to use those resources. You can enable the flex throttles option for all states or enable and disable it by state.

When setting flex throttles, you define the following things:

• The Flex Throttle Action Interval (when there are available resources, how long TASM waits after releasing requests from the delay queue before repeating the action)
• The events that trigger flex throttle actions
• What happens when the triggering events occur

You can enable the flex throttles option in evaluation mode before activating it. In evaluation mode, no requests are released when the triggering event occurs. Instead, the TDWM event log lists which requests would have been released if the option had been activated.