Find out Teradata AMP (vprocs) Count

Raymond Tang Raymond Tang 0 787 0.48 index 12/26/2020

Teradata AMPs are the parallel distributed storage and computing unit in a Teradata server. We can use HASHAMP function to calculate the total AMP count (virtual processors) in a Teradata system.

HASHAMP function

HASHAMP function returns the identification number of the primary AMP corresponding to the specified hash bucket number. If no hash bucket number is specified, HASHAMP returns one less than the maximum number of AMPs in the system.

Code snippet

SELECT HASHAMP()+1 AS "AMP Count"
teradata

Join the Discussion

View or add your thoughts below

Comments