Business Goals | Teradata Vantage - 17.00 - Business Goals - 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

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