17.10 - SLG Response Time - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Advanced SQL Engine
Teradata Workload Management
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

DBAs use SLGs to measure how well a workload performs and to identify performance trends. Most SLGs are based on response time with a service percentage, such as < 2 seconds 90% of the time. Sometimes SLGs are based on throughput (completions), such as > 100 requests per hour. DBAs investigate missed SLGs so they can resolve the issues and meet SLG goals in the future. The workload event SLG Response Time detects missed SLGs.

It is worthwhile to distinguish whether an issue exists in only one workload, a set of common workloads, or all workloads. Individual SLG misses or a set of common workload misses point to a problem that a DBA can solve by using TASM to adjust resource consumption. When most workloads miss their SLGs, this suggests a capacity problem that TASM controls cannot solve.