15.10 - How Teradata WA Sets SLGs - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

prodname
Teradata Workload Analyzer
vrm_release
15.10
category
User Guide
featnum
B035-2514-035K

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.