Network Management
Perfstack availability traces showing Status grey lines in SolarWinds Platform
Why do some of the Perfstack traces show grey (unknown)?
First published date
Last published date
Overview
When adding entities in the Perfstack chart, the Status entity does not follow the same availability comparison as the others entities, as it shows part in grey before some dates, and the other entities show the correct values.
Product section
Cause
This is by design. Status data are loaded from the NetObjectDownTime DB table, and this table has its own retention interval.
The Status data stored there shows the time when it changed until UP.
You can use the following SWQL code to check the affected node.
SELECT n.EntityId, n.DateTimeFrom AS DateTimeStamp, n.DateTimeUntilNow,
n.State AS Value, n.TotalDurationMin * 60 AS Resolution,
si.StatusName AS Status, n.NodeId as Id, si.Color
FROM Orion.NetObjectDowntime AS n
INNER JOIN Orion.StatusInfo AS si ON n.State = si.StatusId
WHERE n.EntityId = XXX AND n.EntityType = 'Orion.Nodes'
ORDER BY n.DateTimeFrom
All time intervals from NetObjectDownTime where DateTimeUntil is older than the retention setting are removed during Database Maintenance.
If the node status hasn't changed, then the above cleanup is ignored.
If you need to get more Status information, then you need to increase the Downtime retention as informed above.
Resolution
- The Perfstack retention data for availability is set in Settings > Polling Settings > Downtime History Retention which has a default value of 7 days.
- The above retention status is checked as part of the regular database maintenance (VWHERE DateTimeUntil < (currentDate - 7 days). The maximum is 60 days.
- If the node status hasn't changed, then the above cleanup is ignored, and this explains why some of the traces may show as green for longer than the 7 days setting.