Viewing or Modifying SLGs - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
sef1527114222310.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Service Level Goals (SLG) can be viewed in graph format, and the settings modified using the SLG Recommendations Window.
  1. From left window of the Workload Report, expand the workload, and then click the SLG Graph icon. The SLG Recommendations window appears.


    Alternatively, display the SLG Recommendations window by selecting Rule Set > Workloads > Calculate SLGs from the Teradata WA menu.
  2. In the SLG Recommendations window, view the default parameters and resulting service level recommendations, along with the displayed chart.
  3. Change the options as described in the following table.
    Option Description
    SLG Parameters Displays the service parameters that can be viewed or modified to generate SLG recommendations. Click Response Time (the default), or Throughput as appropriate.
    When a listed parameter is selected, the following is true:
    • Parameter appears as the horizontal axis of the chart
    • Value of this parameter can be edited in the SLG Recommendations table displayed beneath the chart; no other options are available for editing.

    Changing the setting prompts Teradata WA to update the graph immediately. Response Time or Throughput SLGs can be saved in the TDWM database, not both.

    OpEnv Displays the available operating environments. Click an OpEnv in the list box or accept Always as the default.

    Changing the setting prompts Teradata WA to update the graph immediately.

    Start Date / End Date Displays the DBQL date range depicted in the graph. This is in YYYY-MM-DD format.
    Set Manually Allows modification of the recommended service levels. This check box is unchecked by default.
    SLG Recommendations Changes the selected service parameter’s recommended value (shown highlighted in white). No other values are available for editing (shown shaded).

    Arrival rate, Response Time, Throughput, and Service Percent are displayed. The response time goal shown is the value that would satisfy a 80% goal.

    Recommend on current Service percent Displays the current performance baseline that Teradata WA automatically uses for determining service level recommendations. You can adjust this as appropriate.
    Factor by Modifies the SLG parameter, with a factor of 1 being the same as today, 0.1 being 10 times faster than today, 10.0 being 10 times slower than today.
  4. When satisfied with the new values, click Apply.