Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Orion Platform > Orion Documentation > Optimization Guide > Optimize the data you retain in the database

Optimize the data you retain in the database

Created by Magdalena.Markova, last modified by Magdalena.Markova on May 31, 2018

Views: 1,497 Votes: 0 Revisions: 7

Updated: May 30, 2018

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.

    optimize_polling_settings.png

  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:

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
  1. Click Settings > All Settings > Polling Settings.
  2. Review and adjust the retention settings for keeping specific data in the database:

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.

    logadjuster.png

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

Last modified

Tags

Classifications

Public