Detecting Skew - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
pzr1600284001549.ditamap
dita:ditavalPath
pzr1600284001549.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage

Either CPU or I/O skew percent exceptions can indicate skew. TASM exceptions detect skewed requests based on the number of AMPs active in the request step. A group-AMP request that uses about the same processing time for each AMP involved would not be detected as skewed, even though some AMPs are not affected by the request.