Enabling and Configuring Flex Throttles - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Throttles.
  3. In the Workloads with Throttles Defined section, click Flex Throttles.
  4. Click the Enable Flex Throttles check box.
  5. [Optional] To use the flex throttles in evaluation mode, select the Enable Evaluation Mode check box. In evaluation mode flex throttles have no actual effect on your system, but the hypothetical results are reported in the TDWM event log.
  6. Under Triggering Events, designate the Available AWT conditions to trigger an event.
    Option Description
    Number of AMPs with available AWTs Specify the minimum number of AMPs with available AWTs. The event will be triggered if this number or more are available.
    Number of Available AWTs Specify the minimum number of available AWTs. The event will be triggered if this number or more are available.
    Qualification Specify the number of minutes for which both conditions above must be met to trigger the event.
  7. [Optional] To further restrict the event definition to occur only when there is a minimum level of CPU Utilization, select the check box and define the options.
    Option Description
    System CPU Specify the minimum system CPU utilization percentage. The event will be triggered if the CPU utilization is less than or equal to this value.
    Qualification Specify the number of minutes for which the minimum system CPU must be maintained to trigger the event. The average value of this metric must exceed the threshold for this time period.
  8. Under Actions, enter the Number of Queries to Release on the flex throttle action interval. The number of queries cannot be more than twice the number specified for Number of Available AWTs. The flex throttle action interval is defined in the Other tab of the General category on the ruleset toolbar.
  9. [Optional] Select actions to occur when a flex throttle event starts or ends.
    Action Description
    Send Alert Specifies the action to trigger.
    Run Program Specifies the Alerts registered programs to trigger.
    Post to QTable The string you enter is posted to the QTable.
  10. Click Save.