16.10 - What is Workload Management? - Teradata Workload Management

Teradata Database Workload Management User Guide

Teradata Workload Management
June 2017
User Guide
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 Teradata Database 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 Teradata Database 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 in Teradata Database.
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 book 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.