DBC Queries

To find the number of nodes

Select count(distinct nodeid) from dbc.resusagescpu

To find the number of AMP's

Select nodeid,count(distinct Vproc) from dbc.ResCpuUsageByAmp

SELECT HASHAMP()+1