1 Reply Latest reply on Jul 9, 2009 4:49 PM by bshopp

    Report Writer & APM COMPONENT by CPU & Memory Utilization

    lchance

      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

      FROM
      Nodes INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID = APM_AlertsAndReportsData.NodeId)


      WHERE 
      (
        (APM_AlertsAndReportsData.DisplayType LIKE '%process%') OR
        (APM_AlertsAndReportsData.DisplayType = 'windows service')
      )

       

      ORDER BY 6 DESC, 8 DESC