16.20 - TASM: Flex Throttles - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

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 Teradata Vantage™ Workload Management User Guide, B035-1197 or Teradata® Viewpoint User Guide, B035-2206.