Polling Interface Sample Data - 5 Minutes Intervals

Question

Hi all,

Running into a bit of an issue with a small project and wanted to get some feedback from the community.  We currently use NPM to monitor all interfaces and nodes on our backbone network.  I need to be able to pull the actual sample data for any given interface for a full month.  This is typically very easy via the "View Chart Data" or "View Chart Data in Excel" options on the NPM website.  However, if I try to select 5 minute samples for anything greater that 7 days, NPM tells me "Too many Samples" and will not pull the data.  Is there any way around this limitation that someone can recommend?  If SQL is the way to go, I'd love a sample configuration for a Report if you have one.  Any info would be greatly appreciated, thank you!

Derek Sperry

zzz · Answer

That's how Orion currently has set up with its database- it will at set interverals aggregate and combine data points to reduce the number of entries, then finally deleting it after a year or so. Ex: after 1 days, it may take the 90 sec datapoints and combine them into 30 min statistics. Then after 7 days, it'll become hourly data, etc. This is (mostly) set on the polling settings page for NPM. Other data points, such as NTA, are kept seperatedly and have their own settings.

You can set it up for bigger, but will get warnings regarding table size and such.

Ronal1943 · Answer

I am not sure if this fits here and I am fairly new to the the Orion. I am trying to get min/max response time charts at 5 minute intervals up to 3 months back on a consistant basis. I have found that the further back I go beyond around 57 days, I have to start increasing the intervals until I finally am at 1 sample in a 24 hours period. For measuring and tracking Performance Comparisons for device moves (before and after) this makes it nearly impossible. Is there any kind or work around for this issue or is it just what it is?

mdriskell · Answer

You need to adjust your database retention settings if you need to keep more granularity.  By default I believe it is set to 7 days for detailed.  Be aware that this could cause large database sizes depending on the number of elements you are polling.

To change this go to settings, polling settings, then the Database retention settings.  Note that once you change this you will have to wait until SW collects additional data prior to running your report.  I would use this with caution like I said as this could seriously hinder performance of your database.