Using Teradata SQL: How to find the number of AMPs and Nodes

Sometimes it can be useful to know how many AMPs (Access Module Processors) and Nodes a particular Teradata installation has. This is especially true for the AMPs as you should always try to spread any queries or activities you run across as many AMPs as possible. This helps to maximise performance and the amount of system resources you can use for your query. Fortunately, this is very easy in Teradata :-). Just run the two queries below.

To find the number of AMPs

SELECT HASHAMP()+1 AS Nbr_of_AMPs;

To find the number of Nodes

SEL COUNT(DISTINCT NodeId) AS Nbr_of_Nodes FROM DBC.ResUsageSpma;

As always I didn't invent these, I found them on the Teradata Community pages.

"Nearly all men can stand adversity, but if you want to test a man's character, give him power." - Abraham Lincoln