Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

NPM Data Loss

Hi, May i know if changing the option from 30 to 7 for "Detailed Statistics Retention" will incur a lost of data?

After i configured the option and also pressing "Database Maintenance" from Orion Core Poller, any data before 7 days ago are missing.

Per Interface

- min/max/average bps

- min/max/average packets

- in/out errors and discards

- total bytes transferred

2015-10-21 13_25_03-Orion Polling Settings.jpg

Find more posts tagged with

Accepted answers

All comments

professionalusername

You shouldn't lose any data by changing the detailed statistics to a lower number. That number just sits in a table and then gets used a value inside of the stored procedures that aggregate the data. What I'm guessing is that the data is still in the db but not being queried for some reason. Query your database for "Select distinct datetime from interfaceerrors" and see if the earlier dates still exist.

Matthew Hawks

Loop1 Systems

sean.martinez

Changing the number of days does not affect the data until the Database Maintenance has been ran.

More than likely the chart that you are using has Sample Selection set to lower than 1 hour. This will cause the lines to not form and you may see a few single data points, because the data is aggregated from every 10 minutes to a single data point for Min, Max, and Average per hour. Changing the Sample to 1 hour if you are looking at the last 90 days. After 90 days the Sample Interval needs to change to once a day to still form the lines correctly.

mikenai

Looking at this, i presume that there is no data left?

2015-10-22 08_15_12-Custom Chart - Min_Max_Average bps In_Out.jpg

mikenai

I've tested with multiple sample values, of both higher and lower. But doesnt seem to help, no matter how i zoom in or out of the graphs. It looks like there is no data before 14-Oct-2015.

The result is the same no matter which interface/equipment i choose from SolarWinds Inventory.

Don't mind that i have mask'ed out the equipment name.

2015-10-22 08_16_26-Custom Chart - Min_Max_Average bps In_Out.jpg

HolyGuacamole

I would imagine it will drop the data since the data retention now says you only want to keep detailed data for 7 days. So, any detailed data that is more than 7 days old would be purged when the maintenance kicks in.

mikenai

Yup, but what about the hourly data more than 7 days ago? I would presume that it should still be retained.