What is Workload Management | Teradata Vantage - 17.10 - What is Workload Management? - 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)
A workload is a class of database requests with common traits whose access to the database can be managed with a set of rules. Workloads are useful for:
  • Setting different access priorities for different types of requests.
  • Monitoring resource usage patterns, performance tuning, and capacity planning.
  • Limiting the number of requests or sessions that can run at the same time.

Workload management is the act of managing Vantage workload performance by monitoring system activity and acting when pre-defined limits are reached. Workload management uses rules, and each rule applies only to some database requests. However, the collection of all rules applies to all active work on the platform.

Users can employ Teradata Workload Management as a performance tool to direct how Vantage accomplishes expectations.

Teradata Workload Management offers two different strategies. See your Teradata representative for details about the license required for each strategy.

Teradata Active System Management (TASM)
TASM performs full workload management.
TASM gives administrators the ability to prioritize workloads, tune performance, and monitor and manage workload and system health. TASM automates tasks that were previously labor-intensive for application DBAs and operational DBAs.
Teradata Integrated Workload Management (TIWM)
TIWM provides basic workload management capabilities to customers without full TASM. TIWM offers a subset of TASM.

While this document touches upon TIWM, it focuses primarily on TASM. For more information on the differences between TASM and TIWM, see A Comparison of TASM and TIWM Features.