How Teradata WA Sets SLGs - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

How Teradata WA Sets SLGs

Teradata WA recommends service level goals for workloads to achieve the greatest responsiveness. Teradata WA sets goals using current performance as a baseline. For example, Teradata WA might detect that, under current performance, for 80 percent of queries, the maximum response time is 300 seconds. Therefore, Teradata WA would set the service-level goal for response time as 80 percent, meaning that 80 percent of queries process in less than 300 seconds. The user can choose to accept the recommended goals or modify various settings as reporting needs dictate.

Using service level goals is recommended, although not required.