State Matrix Considerations | Teradata Vantage - State Matrix Considerations - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage

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.