17.00 - SLG Response Time - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K

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.