Custom Chart w CPU and Memory Average and Peak

mprobus

I am trying to create a custom chart that includes both CPU and Memory averages and peaks.  I found values for the cpuload average and max and the memory average percentage.  However, the peak memory is measured in bytes and not percentage.  So, I'm thinking I need to use SQL to calculate the peak percentage value.  Anyone have any ideas of how to do this?  I'm having difficulty finding the right tables to get all of the information.

mprobus

Came up with the following for anyone that is interested.  It will not graph the results, so I can't create a custom chart out of it, but a custom table works.

SELECT        Nodes.Caption AS NodeName, CPULoad.DateTime, CPULoad.AvgLoad as CPUAverage, CPULoad.MaxLoad AS CPUMax, CPULoad.AvgPercentMemoryUsed as MemAverage,

                         ROUND(CPULoad.MaxMemoryUsed / CPULoad.TotalMemory * 100, 2) AS MemMax

FROM            Nodes INNER JOIN

                         CPULoad ON Nodes.NodeID = CPULoad.NodeID

WHERE        (CPULoad.DateTime BETWEEN CONVERT(DATETIME, '2016-06-01 00:00:00', 102) AND CONVERT(DATETIME, '2016-07-15 00:00:00', 102)) AND (Nodes.Caption LIKE 'XXXX%')

GROUP BY Nodes.Caption, CPULoad.AvgLoad, CPULoad.AvgMemoryUsed, ROUND(CPULoad.MaxMemoryUsed / CPULoad.TotalMemory * 100, 2), CPULoad.MaxLoad, CPULoad.DateTime,

                         CPULoad.AvgPercentMemoryUsed

ORDER BY DateTime