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

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.