Service Level Goals | Teradata Vantage - 17.10 - Service Level Goals - 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)
This feature is available only on systems with TASM.

Important workloads often come with service level goals to indicate their performance objectives. This is especially true for tactical workloads. TASM lets you set goals on workloads to reflect the needs of the business.

Service level goals are measurable using either of the following metrics:
Response Time
The percentage of completed requests that meet the response time goal (for example, 2 seconds or less 99% of the time)
Requests completed per hour (for example, 1,000 requests per hour)

Service level goals can trigger system health conditions via the workload events for SLG Response Time or SLG Throughput. You can also use service level goals in reports, such as using DBQLogTbl.ResponseTimeMet.

Service level goals are most appropriate for Tactical and SLG tier workloads.