Optimize the database used by Orion Platform products

This topic applies to all Orion Platform products.

Optimize your deployment by changing how often the data is polled, the time after which the detailed data is aggregated and summarized, and how long you need to keep historical data in the database.

Database optimization tips

  • Retain the default polling and retention settings.
  • Use the SIMPLE recovery model of your SQL database.
  • Store the data files and log files on different drives.
  • Do not allocate 100% of memory to MS SQL Server services. Allocating 75% should leave enough breathing room for the operating system.

Check what tables are taking up most space in your Orion SQL database

Changing the default polling and retention settings can result in your database filling up fast.

  1. Click Settings > All Settings > Database Details.
  2. Scroll down, and click Database Statistics.
  3. Review the most space-demanding tables, and check the polling and retention settings.
  4. Compare the number of reserved kb and the actual data in the database. Check polling and retention settings for tables where the actual data is getting close to the reserved limit.

If the largest tables are for Syslogs or SNMP traps, consider optimizing them.

Set polling settings back to default

  1. Click Settings > All Settings > Polling Settings, and make sure the polling intervals and intervals for polling statistics are set to default values.

  2. Set polling settings for specific metrics back to default:
    • Statistics poll interval for hardware health polling - 10 minutes
    • Multicast route table poll interval - 10 minutes
    • Routing neighbor poll interval - 5 minutes
    • Routing table poll interval - 180 minutes
    • VRF update poll interval - 180 minutes
    • Wireless heat maps: default client signal strength poll interval - 5 minutes

Set retention settings back to default

Retention settings specify how long the data is kept in the database. By customizing retention settings, you can specify how long to keep data for some metrics, such as interface availability, wireless statistics, in the database.

The less data you keep, the better performance your database can have. SolarWinds recommends that you keep the default settings.

Retention settings are further divided into detailed, hourly, and daily.

  • Detailed retention specifies how long the detailed statistics are in the database. After this time, Orion Platform summarizes the detailed statistics for the metric into one record for each hour.
  • Hourly retention specifies how long hourly statistics are kept in the database. After this time, the statistics are further summarize into daily statistics.
  • Daily retention are deleted after the time you specify as Daily retention for statistics.

To reset defaults for retention settings:

  1. Click Settings > All Settings > Polling Settings.
  2. Review and adjust the retention settings for keeping specific data in the database:
  3. Metric Default detailed retention Default hourly retention Default daily retention
    Node statistics 7 days 30 days 365 days
    Container stats 7 days 30 days 365 days
    Hardware health 7 days 30 days 365 days
    Interface availability 7 days 30 days 365 days
    Wireless 3 days 14 days 180 days
    UnDP 3 days 14 days 180 days
    Events 30 days
    Syslogs and Traps 7 days

Optimize log files

Log files are an important diagnostic tool. If you increase the logging levels to DEBUG, you might experience disk space issues.

Before you clean up log files, contact other teams in your organization that use Orion Platform products and get their approval.

Clean up orphaned log files

Delete the log files you do not need, such as files with .log or .log.1-5 suffix.

If your Orion Platform is not installed in the default location, adjust the path to correspond with your deployment.

  1. Open the command line as an administrator.
  2. Run the following commands:

    del /f /q /s C:\programdata\solarwinds\*.log

    del /f /q /s C:\programdata\solarwinds\*.log.*

Reset logging to default

  1. Launch the Orion Log Adjuster in the SolarWinds Orion > Documentation and Support program folder.
  2. Click Reset to defaults, and click Apply.

For more information, see the article on Low disk space due to large diagnostics.