Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Orion Platform > Orion Documentation > Orion Platform Administrator Guide > Manage Orion Polling Engines > Run the database maintenance

Run the database maintenance

Database maintenance is an automatic process that optimizes the size of your SolarWinds Orion database. During maintenance, the data collected for a certain period are aggregated and new statistical values, based on the aggregated data, are calculated. The data are discarded, and only the aggregated statistics are retained.

Database maintenance runs every day at a specified time. Depending on the data granularity and retention period, you may need to configure your database differently. Keep in mind that the more granularity and the longer the retention period, the larger the database.

Check the database size

  1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
  2. Add your database server and expand it.
  3. Right-click your SolarWinds Orion database, and select Database Details.

    File:Success_Center/New_Articles/NPMAG_forMT_final/100/ViewDatabaseDetails.png

    The database size is displayed in the Properties tab.

    File:Success_Center/New_Articles/NPMAG_forMT_final/100/DatabaseDetailsInDBManager.png

Specify the time to run database maintenance

Make sure database maintenance runs after business hours.

  1. Log in to the Orion Web Console using an administrator account.
  2. Click Settings > All Settings.
  3. Click Polling Settings in the Thresholds & Polling grouping.
  4. Scroll down to Database Settings, and enter an Archive Time.

    File:Success_Center/New_Articles/NPMAG_forMT_final/100/DatabaseSettings_ArchiveTime.png

  5. Click Submit.

Adjust retention periods

Data for collected statistics are retained for a specified time. Shorten the retention periods to save storage space in your database.

  1. Log in to the Orion Web Console using an administrator account.
  2. Click Settings > All Settings.
  3. Click Polling Settings in the Thresholds & Polling grouping.
  4. Scroll down to Database Settings, and adjust the retention periods.

    The detailed data are retained for the specified period and summarized into hourly data. Hourly data are then summarized into daily statistics, and daily statistics are discarded after the specified time.

    The shorter the retention period, the greater effect the setting has on the database size.

    File:Success_Center/New_Articles/NPMAG_forMT_final/100/SetStatisticsRetention.png

    You can also adjust retention periods for other statistics.

    Changing the detailed retention period has the greatest effect on the database size.

    Assuming a 10-minute polling interval, one new entry is added to the database for each monitored object every 10 minutes. That means 144 new entries a day are added for each monitored object during the Detailed Statistics Retention period. In the Daily Statistics Retention period, only one entry a day is added to the database for each object.

  5. Click Submit to commit the changes.

Launch database maintenance manually

  1. Start Database Maintenance in the SolarWinds Orion > Advanced Features program folder.
  2. Click Start.
 
Last modified

Tags

Classifications

Public