Network Management

How does database summarization work

The article provides details on how the database summarization process works.

First published date

10/23/2018 2:45 PM

Last published date

4/23/2020 10:30 PM

Overview

This explains the summarization process by using default retention settings.

Product section

Network Performance Monitor

Resolution

The summarization process is used to keep the size of the database to a minimum as described in this example.
The following default retention settings or periods are used to poll an interface every nine minutes.

Detailed for 7 days
Hourly for 30 days
Daily for 365 days

The following lists the database summarization process:

The raw information that is polled from the interface every nine minutes is stored in the Detailed table. This table will have around six data points every hour.
When the information stored in the Detailed table reaches its retention period of 7 days, it will move to the Hourly table.
When the information stored in the Hourly table reaches its retention period of 30 days, it will move to the Daily table. This table will have one data point for each day, which is the average of the data points for that day stored in the Hourly table.
Information stored in the Daily table that reaches its retention period of 365 days will be deleted from the tables.

The Database Maintenance process is run, by default, every day at 2:15 AM.
Go to Orion Web > Settings > All Settings > Polling Settings page to configure the retention settings.

Default Retention settings for all products:

SettingID	Units	CurrentValue	DefaultValue
HardwareHealth-RetainDaily	days	365	365
HardwareHealth-RetainDetail	days	7	7
HardwareHealth-RetainHourly	days	30	30
NetPath-Settings-Retain NetPath Detail	days	30	30
NPM_Settings_InterfaceAvailability_Retain_Daily	days	365	365
NPM_Settings_InterfaceAvailability_Retain_Detail	days	7	7
NPM_Settings_InterfaceAvailability_Retain_Hourly	days	30	30
NPM_Settings_RoutingDefaultRouteChange_Retain_Days	days	30	30
NPM_Settings_RoutingFlap_Retain_Days	days	30	30
NPM_Settings_RoutingNeighbor_Retain_Days	days	30	30
NPM_Settings_UnDP_Retain_Daily	days	365	365
NPM_Settings_UnDP_Retain_Detail	days	7	7
NPM_Settings_UnDP_Retain_Hourly	days	30	30
NPM_Settings_Wireless_Retain_Daily	days	365	365
NPM_Settings_Wireless_Retain_Detail	days	7	7
NPM_Settings_Wireless_Retain_Disappeared_AccessPoints	days	7	7
NPM_Settings_Wireless_Retain_Hourly	days	30	30
SWNetPerfMon-Settings-Retain Auditing Trails	days	365	365
SWNetPerfMon-Settings-Retain Container Daily	days	365	365
SWNetPerfMon-Settings-Retain Container Detail	days	7	7
SWNetPerfMon-Settings-Retain Container Hourly	days	30	30
SWNetPerfMon-Settings-Retain Daily	days	365	365
SWNetPerfMon-Settings-Retain Detail	days	7	7
SWNetPerfMon-Settings-Retain Discovery	days	60	60
SWNetPerfMon-Settings-Retain Events	days	30	30
SWNetPerfMon-Settings-Retain Hourly	days	30	30
VIM_Setting_Daily_Retain	days	365	365
VIM_Setting_Detailed_Retain	days	7	7
VIM_Setting_Hourly_Retain	days	30	30
WLP_Settings_Wireless_Retain_SessionHistory	days	90	90

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.