Query to find number of Amps per node ? TDWORLD | May 24, 2014 | Important Queries | No Comments Query 15) Query to find number of Amps per node Answers > Select nodeid,count(distinct Vproc) from dbc.ResCpuUsageByAmpView; Tags:Amp, Amps per node, dbc.ResCpuUsageByAmpView, VPROC Related Posts How to find the performance logs of a query ? How to identify if query is bad No Comments | May 24, 2014 How to list down the unwanted stats collected on Teradata environment ? No Comments | May 24, 2014 PRPD – Partial Redistribution Partial Duplication No Comments | Apr 10, 2016 When I get an error stating 'NO MORE SPOOL SPACE IN USER' what does it mean? No Comments | May 24, 2014 About The Author tdworld2013 Add a Comment Cancel reply Your email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Website: Save my name, email, and website in this browser for the next time I comment.