To find the number of APMs TDWORLD | May 24, 2014 | Important Queries | No Comments Query 17) To find the number of APMs: Answers > sel distinct VprId from DBC.ResUsageSvpr where VprType=’AMP’; sel hashamp(0)+1 Select count(distinct vproc) from dbc.ampusage sel count(distinct VprId ) from DBC.ResUsageSvpr where VprType=’AMP’; Tags:AMPS, Amps per node, How to find Amps, Teradata AMP Related Posts When I get an error stating 'NO MORE SPOOL SPACE IN USER' what does it mean? No Comments | May 24, 2014 How to find the AWT UTILIZATION FOR PARTICULAR TIMEFRAME ? No Comments | May 24, 2014 How can you determine I/O and CPU usage at a user level in Teradata? No Comments | May 24, 2014 How to generate a list of tables which are of type " SET " in Teradata ? 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.