Skewed Query Processing Across Nodes | Teradata Vantage - Skewed Query Processing Across Nodes - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantage™

Parallel node efficiency is a matter of how evenly the workload is shared among nodes. The more evenly the nodes share the work, the higher the efficiency.

You can calculate parallel node efficiency by dividing average node utilization by maximum node utilization, and identify skewed processing across nodes.

IF parallel node 
efficiency … THEN …
is nearly 100% the better the nodes are working together.
falls significantly below 100% in that time period, one or a few nodes are working harder than the others.
falls below 60% more often than a couple of sampling periods your installation is not taking advantage of the parallel architecture.

Possible causes of skewed node processing include:

  • Down node
  • Non-Vantage application running on a TPA node
  • Co-existence system where the number of AMPs per node is not optimally balanced with different node powers.
  • Poor AMP efficiency