I have the poll intervals configured to be checked every 120 seconds.
The responsetime table shows the polls of each node in 120 second intervals.
Which tables are used to store the interface availability and volume availability in the 120 second intervals?
The InterfaceAvailability_Detail table is storing the data in 10 min intervals.
For interfaces try the InterfaceAvailability view (use InterfaceID and NodeID to tie the back to Interfaces and Nodes tables respectively), this view is from the InterfaceAvailability_detail, InterfaceAvailability_hourly and InterfaceAvailability_daily tables.
Volume availability doesn't exist as a straight metric, but you should be able to calculate it from VolumePerformance view. (which shows the VolumePerformance_Hourly_detail VolumePerformance_Hourly and VolumePerfromance_Daily tables).
I appreciate your input but I am not sure if that is correct.
If SolarWinds is polling the interface every 2 minutes the table should have an entry every 2 minutes. The values I am seeing are ten minutes apart.
Agreed, I have spent the past half an hour trying to find an interval with less than ten minutes, in any interface database table.
I am scratching my head myself.
I spent quite some time trying to find it. Looking at table dependencies hoping to have a Eureka moment. I even opened a case to see if SolarWinds support would be able to point me in the right direction.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.