16.10 - TASM: Flex Throttles - Teradata Database

Teradata Database Release Summary

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Release Notes
featnum
B035-1098-161K

Workload throttles limit the number of active requests to reduce resource contention and improve system performance. However, when a system is operating under capacity, workload throttles can prevent full use of system resources. Before this release, database administrators could take advantage of less busy times by manually releasing throttled work or continually adjusting throttles as system conditions changed. Both options were labor-intensive and inflexible.

Now Flex throttles can detect available resources and automatically release some requests delayed by workload throttles. To accomplish this, users can accept the defaults or define the following values in the Viewpoint Workload Designer portlet:
  • Whether or not the Enable Flex Throttles option is activated for the ruleset
  • When system resources are considered available
  • What action TASM should do when it detects available resources
  • Which workloads in which states can use Flex throttles

Benefits

  • Greater flexibility allows DBAs to prevent system overload yet benefit from periods with free resources.
  • Greater automation reduces DBA workload yet still allows DBAs to intervene if and when desired.

Considerations

  • Flex throttles cause concurrent request numbers to vary, so DBAs may wonder if their throttles are acting normally. To assess the impact of enabling the feature, you can try it in evaluation mode first. In evaluation mode, the TDWM event log reports detailed hypothetical results.
  • This feature is available only on SLES 11 systems with TASM.

Additional Information

For more information, see Workload Management User Guide or Viewpoint User Guide.