6 Replies Latest reply on Oct 21, 2015 10:06 PM by mikenai

    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

        • Re: NPM Data Loss

          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

          • Re: NPM Data Loss

            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.

              • Re: NPM Data Loss

                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