Skew Tab for Teradata Database - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
The Skew tab displays details about the level of skew in the query or session. The Skew tab does not display when the Delay tab is present.
Skew Information Description
Highest AMP with the highest CPU utilization or I/O count
2nd Highest AMP with the second highest CPU utilization or I/O count
3rd Highest AMP with the third highest CPU utilization or I/O count
Average AMP with the lowest CPU utilization or I/O count
3rd Lowest AMP with the second lowest CPU utilization or I/O count
2nd Lowest AMP with the third lowest CPU utilization or I/O count
Lowest Average CPU utilization or I/O count across all AMPS
Session Skew Difference between the highest and the average values
Participating AMPs Total number of AMPs participating for this session during the last session collection interval