Configure Database Settings in the Orion Platform

This topic applies to all Orion Platform products.

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

Shortening retention periods can improve your database performance. However, if you reduce retention periods or otherwise change the default settings, 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 KB article for database best practices.

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

Archive Time

Configure the time of day when the maintenance of the SolarWinds Orion database runs. See Database maintenance in the Orion Platform.

Index Defragmentation

Select the box to enable database index defragmentation. Defragmenting the database helps troubleshoot performance issues.

Timeout for Index Defragmentation

Set a timeout for index defragmentation. By default, it is 3600 seconds.

Enable/disable auto reset logging levels to logging defaults

Select to automatically reset logging levels to defaults during Maintenance. Enabled by default.

Auditing Trails Retention

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

Detailed Statistics Retention

Specify the time period in which all statistics collected in the SolarWinds Orion database are summarized into hourly statistics. By default, this period is seven days.

Hourly Statistics Retention

Specify the time period in which all statistics collected in the SolarWinds Orion database are summarized into daily statistics. By default, this period is 30 days.

Daily Statistics Retention

Specify how long daily statistics are kept in the SolarWinds Orion database. After the specified time, the daily statistics are deleted. By default, this period is 365 days.

Container Detailed Statistics Retention

Specify when group statistics are summarized into hourly statistics. The default is seven days.

Container Hourly Statistics Retention

Specify when hourly group statistics are summarized into daily statistics. The default is 30 days.

Container Daily Statistics Retention

Specify how long group statistics are kept in the SolarWinds Orion database. The default is 365 days.

Baseline Data Collection Duration

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

Delete Stale Interfaces

If no new data is polled for an interface for a specified time and the Orion 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

Specify the time interval (in days) after which stale interfaces are deleted from the SolarWinds Orion database.

Automatically Remove Unknown Volumes

Enable to automatically remove 'unknown' volumes.

Remove Unknown Volumes After

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

Detailed Wireless Statistics Retention

Specify the number of days until the detailed wireless statistics in the SolarWinds Orion database are summarized into hourly statistics. By default, this period is three days.

Hourly Wireless Statistics Retention

Specify the number of days until the hourly wireless statistics are summarized into daily statistics. By default, this period is 14 days.

Daily Wireless Statistics Retention

Specify the number of days until the daily wireless statistics are deleted from the database. By default, this period is 180 days.

Events Retention

Specify the number of days until the all network events data are deleted from the SolarWinds Orion database. By default, this period is 30 days.

Syslog Messages Retention

Specify the number of days until all data related to received Syslog messages are deleted from the SolarWinds Orion database. By default, this period is seven days.

Trap Messages Retention

Specify the number of days until all data related to received trap messages are deleted from the SolarWinds Orion database. By default, this period is 30 days.

Max Alert Execution Time

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

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

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

Specify the number of days until all network discovery profiles are deleted from the SolarWinds Orion database. The retention starts when a discovery is first defined. By default, this period is 60 days.

Downtime History Retention

Specify the number of days until the downtime history is deleted from the database. By default, this period is seven days.