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.