Business Goals | Teradata Vantage - 17.10 - Business Goals - Advanced SQL Engine - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)

Data warehouses today run a complex mix of applications, all competing at once for database resources. Frequent data loading competes with business-critical tactical requests and strategic requests for business decision-making. Each workload type has different system resource needs and user response time expectations. TASM brings order to this environment. DBAs can use TASM to specify Service Level Goals for selected workloads, monitor performance toward those goals, and define actions for Vantage to take to avoid slowdowns of critical work.

Specifically, users create TASM rules that automate how work submitted to Vantage executes under different circumstances and when the database takes the following actions:
  • Limits sessions, utilities, and requests – delaying or rejecting them when limits are reached
  • Divides system resources among different types of requests
  • Sends alerts or changes the workload of active requests that exceed limits
  • Monitors time of day and system resources and reacts in predefined ways