17.10 - MPS_IncludePEOnlyNodes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Excludes PE-only (AMP-less) nodes from MONITOR PHYSICAL SUMMARY Workload Management API statistics calculations.

Field Group

General

Valid Settings

Setting Effect
TRUE PE-only nodes are included in calculations.
FALSE PE-only nodes are excluded from calculations.

Default

FALSE

Changes Take Effect

After the DBS Control Record has been written.

Related Information

MONITOR PHYSICAL SUMMARY collects statistical system information which includes average, high, and low CPU and disk usage per node. It can be used to determine node-level system skew.

Some sites use PE-only nodes to aid in balancing the AMP workload. Because PE-only nodes are likely to experience substantially lower CPU and disk usage than nodes running AMPs, they can cause the node statistics to appear as if there is a data skew condition, when no such condition exists. In these cases, excluding PE-only nodes provides statistics that more accurately represent the true system workload conditions.

For more information about Teradata APIs, see Teradata Vantage™ - Application Programming Reference, B035-1090.