Setting Service-Level Goals - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Service-level goals (SLGs) help determine if workload management is meeting expectations. You can set throughput and response time service-level goals.
  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Workloads.
  3. Select or create a workload.
  4. Click the Service-Level Goals tab and select one of the following options:
    Option Description
    Response Time Goal Enter a time in seconds, and set a service percentage. For example, if you want 90% of queries to finish within 4 seconds, set a response time of 4 and a service percent of 90. You can have different goals in different planned environments. For example, you can set a response time of 4 seconds for a daytime environment and 12 seconds for a nighttime environment. Metrics graphs show response times.
    Throughput Goal Enter a throughput number per hour. You can set different goals for different planned environments. For example, type 200 if you expect 200 or more queries to be processed per hour.
    No Goal Sets no service-level goal for this workload. This option may be appropriate, for example, for very low priority background workloads.
    You cannot remove a service-level goal from a workload if there is an associated workload event. To remove the service-level goal, delete the associated event.
  5. [Optional] Click a planned environment and set environment-specific goals to override the default settings.
  6. Click Save.