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 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 KB article for database best practices.

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

Setting Default value Description
Archive Time 2:15 am Configure the time of day when the maintenance of the SolarWinds Orion database runs. See Database maintenance in the Orion Platform.
Index Defragmentation Selected Select the box to enable database index defragmentation. Defragmenting the database helps troubleshoot performance issues.
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 Orion database are summarized into hourly statistics.
Hourly Statistics Retention 30 days

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

Daily Statistics Retention 365 days Specify how long daily statistics are kept in the SolarWinds Orion 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 Orion database.

Baseline Data Collection Duration

7 days

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

Delete Stale Interfaces Not selected 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

7 days Specify the time interval (in days) after which stale interfaces are deleted from the SolarWinds Orion database.
Automatically Remove Unknown Volumes Not selected Enable to automatically remove 'unknown' volumes.
Remove Unknown Volumes After 7 days Remove volumes which have no statistical data and have been 'unknown' for longer than configured days.
Detailed Wireless Statistics Retention 3 days Specify the number of days until the detailed wireless statistics in the SolarWinds Orion 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.
Events Retention 30 days Specify the number of days until the all network events data are deleted from the SolarWinds Orion database.
Syslog Messages Retention 7 days Specify the number of days until all data related to received Syslog messages are deleted from the SolarWinds Orion database.

Trap Messages Retention

7 days

Specify the number of days until all data related to received trap messages are deleted from the SolarWinds Orion 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 Orion 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.