I'm trying to make a report showing the TOP x APM Components by MEMORY and CPU and I occassionally will see Component CPU util greater than the CPU Load.
Memory seems to be correct for the Component vs Memory Load Util but as for CPU this seems to be incorrect to me - shouldn't the component CPU always be lower or equal to the CPU total load? Is this my problem making the report or is this a bug?
SELECT TOP 15
Nodes.Caption AS NodeName,
APM_AlertsAndReportsData.ApplicationName AS Application_Name,
Nodes.PercentMemoryUsed AS PercentMemoryUsed,
APM_AlertsAndReportsData.PercentMemory AS Percent_Physical_Memory,
APM_AlertsAndReportsData.ComponentName AS Component_Name,
APM_AlertsAndReportsData.MemoryUsed AS Physical_Memory_Used,
Nodes.CPULoad AS CPULoad,
APM_AlertsAndReportsData.PercentCPU AS Percent_CPU,
Nodes.NodeID AS NodeID
Nodes INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID = APM_AlertsAndReportsData.NodeId)
(APM_AlertsAndReportsData.DisplayType LIKE '%process%') OR
(APM_AlertsAndReportsData.DisplayType = 'windows service')
ORDER BY 6 DESC, 8 DESC
This could be an issue of polling timing maybe? You are pulling APM CPU and NPM CPU values correct? If they both polled at two different times, this could be accurate based on when the poll occured.