Service Level Goals | Teradata Vantage - Service Level Goals - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage
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)
Throughput
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.