Documentation forSolarWinds Platform

Configure Database Settings in the SolarWinds Platform

This topic applies to all SolarWinds Platform products.

Click Settings > All Settings, and in the Thresholds & Polling group, click Polling Settings to configure the settings.

Configure the time of day when the database maintenance runs, and how long data is retained in the SolarWinds Platform database.

For details about retention settings for monitored cloud accounts, see Edit retention settings for cloud-related statistics.

Shortening retention periods can improve your database performance. However, if you increase retention periods, it can cause excessive overhead on your SQL server and introduce issues such as:

  • Increased I/O
  • Increased table sizes
  • Database maintenance issues where nightly maintenance fails to complete or runs indefinitely
  • Web performance issues
  • Chart loading issues

Consider your SQL environment resources, such as disk space and hardware configuration before you change the retention periods. See this SolarWinds support article for database best practices.

It can take more than 10 minutes to propagate some changes to SolarWinds Platform database settings.

Setting Default value Description
Archive Time 2:15 am Configure the time of day when the maintenance of the SolarWinds Platform database runs. See Database maintenance in the SolarWinds Platform.
Index Defragmentation Selected Select the box to enable database index defragmentation. Defragmenting the database helps troubleshoot performance issues.
Online Index Defragmentation Not Selected Select the box to enable online database index defragmentation.
Timeseries Index Defragmentation Only on Sunday Select when you want to run TimeSeries database index defragmentation.
Timeout for Index Defragmentation 3600 seconds Set a timeout for index defragmentation.
Enable/disable auto reset logging levels to logging defaults Selected

Select to automatically reset logging levels to defaults during Maintenance.

Auditing Trails Retention 365 days

Specify the number of days until the audit trails statistics are deleted from the database.

Detailed Statistics Retention

7 days Specify the time period in which all statistics collected in the SolarWinds Platform database are summarized into hourly statistics.
Hourly Statistics Retention 30 days

Specify the time period in which all statistics collected in the SolarWinds Platform database are summarized into daily statistics.

Daily Statistics Retention 365 days Specify how long daily statistics are kept in the SolarWinds Platform database. After the specified time, the daily statistics are deleted.

Container Detailed Statistics Retention

7 days

Specify when group statistics are summarized into hourly statistics.

Container Hourly Statistics Retention

30 days

Specify when hourly group statistics are summarized into daily statistics.

Container Daily Statistics Retention

365 days

Specify how long group statistics are kept in the SolarWinds Platform database.

Baseline Data Collection Duration

7 days

Specify the number of days that are included into the baseline.

Interface Baseline Calculation Frequency Only on Sunday

Specify how often the interface baseline calculation runs. This setting is specific for NPM.

Detailed Interface Availability Statistics Retention

7 days Specify the number of days until the detailed interface availability statistics in the SolarWinds Platform database are summarized into hourly statistics. This setting is specific for NPM.
Hourly Interface Availability Statistics Retention 30 days Specify the number of days until the hourly interface availability statistics are summarized into daily statistics. This setting is specific for NPM.
Daily Interface Availability Statistics Retention 365 days Specify the number of days until the daily interface availability statistics are deleted from the database. This setting is specific for NPM.
Delete Stale Interfaces Not selected If no new data is polled for an interface for a specified time and the SolarWinds Platform cannot remap the interface, delete the interface and all data connected with it. Stale interfaces are deleted one hour before the scheduled database maintenance.

Stale Interface Retention

7 days Specify the time interval (in days) after which stale interfaces are deleted from the SolarWinds Platform database
Automatically Remove Unknown Volumes Not selected

Enable to automatically remove 'unknown' volumes with VolumeIndex equal to zero and with the NextPoll value older than set in Remove Unknown Volumes After.

This option is not supported for volumes on Linux Agent devices.

Remove Unknown Volumes After 7 days

Remove volumes which have no statistical data and have been 'unknown' for longer than configured days.

This option is not supported for volumes on Linux Agent devices.

Detailed Wireless Statistics Retention 3 days Specify the number of days until the detailed wireless statistics in the SolarWinds Platform database are summarized into hourly statistics.
Hourly Wireless Statistics Retention 14 days Specify the number of days until the hourly wireless statistics are summarized into daily statistics.
Daily Wireless Statistics Retention 180 days Specify the number of days until the daily wireless statistics are deleted from the database.
Detailed UnDP Statistics Retention 3 days Specify the number of days until the detailed UnDP statistics are summarized into hourly statistics. This setting is specific for NPM.
Hourly UnDP Statistics Retention 14 days Specify the number of days until the hourly UnDP statistics are summarized into daily statistics. This setting is specific for NPM.
Daily UnDP Statistics Retention 180 days Specify the number of days until the daily UnDP statistics are deleted from the database. This setting is specific for NPM.
Events Retention 30 days Specify the number of days until the all network events data is deleted from the SolarWinds Platform database.
Alerts History Retention 90 days Specify the number of days until historical alerts data is deleted from the SolarWinds Platform database.
Max Alert Execution Time 60 seconds Specify the time period until the alerts are disabled if they are not executed successfully. If the defined alert condition persists, Orion continues trying to execute the alert.
Alert Acknowledge URL Text Click here to acknowledge this alert Provide text that is displayed when alerts are available for acknowledgment over the web. When viewing an alert, click the text to acknowledge the alert.
Allow alert actions for unmanaged objects Not selected Select this option if you want the SolarWinds Alerting Engine to execute configured alert actions for unmanaged objects.

Enabling this option increases the processing load on both the SolarWinds server and the database server.

Discovery Retention 60 days Specify the number of days until all network discovery profiles are deleted from the SolarWinds Platform database. The retention starts when a discovery is first defined.

Downtime History Retention

7 days Specify the number of days until the downtime history is deleted from the database.
Enable/Disable Interface Data Obsolete after... Polls Selected

Select the box to display a warning message if interface data is not updated in a number of subsequent polls. Such interfaces are considered to be obsolete. Specific for NPM.

Interface Data Obsolete Poll Count 3

Specify the number of subsequent polls triggering the obsolescence message. For more information, see Why Is Interface Data Obsolete?