State Matrix Considerations | Teradata Vantage - 17.10 - State Matrix Considerations - 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)

You rarely need more than a few states. A simple matrix is easier to set up, monitor, and tune. Keep the size of the state matrix and the number of unique states to a minimum.

If there is no need for additional states, such as when you start using TASM, Teradata recommends that you use the default Base state. While it is easy for TASM to change states, workload management is simpler when there are fewer states to consider. Follow these guidelines to manage states well:
  • Add more states if needed, but keep the number to a minimum. You want to keep the planned environment-related state transitions down to two or three per day.
  • Do not create a unique health condition and a related state for each possible way system health could be degraded. Instead, consider creating one or two new system conditions to represent all possible system degradation scenarios.