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



Jamie Whitehorn

Jamie Whitehorn

A self proclaimed geek who loves technology, data, computers, photography and science; but balances this by spending time with his wonderful better half and their dogs and horses in the countryside.

comments powered by Disqus