Cluster MAX Utilization for RAM

Document created by robert.coppersmith on Oct 30, 2017
Version 1Show Document
  • View in full screen mode

Below is a custom report that a customer requested which shows the overall MAX monthly utilization values of each cluster's physical memory capacity:

 

Sample output:

 

Query:

select

a.Dte as 'Month'

, Cluster

, sum(RAMMax) as 'RAM Max in GB'

 

FROM

(

select

date_format (p.snapshot_time, '%m/%Y') as Dte

, grp.display_name Cluster

, e.display_name as Host

, round(max(if(p.property_type = 'Mem' and p.property_subtype = 'utilization',(p.max_value*p.capacity)/1024/1024,0)),2) as RAMMax

from pm_stats_by_month p

LEFT JOIN entities e on p.uuid = e.uuid

LEFT JOIN entity_assns_members_entities eame ON eame.entity_dest_id = e.id

LEFT JOIN entity_assns eas ON eas.id = eame.entity_assn_src_id

LEFT JOIN entities grp ON grp.id = eas.entity_entity_id

Where grp.name like 'GROUP-PMsByCluster\_%'

group by 1, 2

) as a

group by 1,2

order by 1 desc

1 person found this helpful

Outcomes