1 Reply Latest reply on Mar 15, 2012 11:13 AM by mpbrielle

    Capacity Plannig

    rcabrera.silveira

      Good morning everyone.

      I'm needing to  build reports that manages the  capacity of data links.

      Does anyone have anything similar?

      1. How  many times each interface peaked at 80% occupancy for more than 5  minutes


      2. How  many times each CPU peaked at 80% utilization for more than 5  minutes


      3. How  many times each memory peaked at 80% utilization for more than 5  minutes

      I  built this report, but still could not get in I  need.

       

      SELECT  TOP 1000 Nodes.Caption AS NodeName,
      Interfaces.Caption AS Interface_Caption,
      Count(Interfaces.NodeID)  AS Qtde

      FROM
      (Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID))  INNER JOIN InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID AND InterfaceTraffic.NodeID = Nodes.NodeID)


      WHERE
      ( DateTime BETWEEN 40573 AND 40600.9999884259 )
       AND 
      (
        (Case InBandwidth
          When 0 Then 0
          Else (In_Averagebps/InBandwidth) * 100
      End > 80) OR
        (Case OutBandwidth
          When 0 Then 0
          Else (Out_Averagebps/OutBandwidth) * 100
      End > 80)
      )

      Group By Nodes.Caption, Interfaces.Caption

      Order By qtde desc