Skewed Query Processing Across Nodes | Teradata Vantage - Skewed Query Processing Across Nodes - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
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