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
