What is Workload Management | Teradata Vantage - What is Workload Management? - Analytics Database - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage
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.