Optimize the database used by SolarWinds 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.

• Find out what tables take up most space in the database
• Set polling settings to defaults
• Set retention settings to defaults
• Optimize log files

Check what tables are taking up most space in your SolarWinds Platform 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.

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, SolarWinds 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:

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

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 SolarWinds 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 SolarWinds 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.