Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Orion Platform > Orion Documentation > Optimization Guide > Optimize system maintenance

Optimize system maintenance

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

Views: 297 Votes: 0 Revisions: 3

Updated: May 30, 2018

To maintain a healthy system, run the database maintenance regularly.

Database maintenance is an automatic process that optimizes the size of your SolarWinds Orion database. Database maintenance aggregates the data collected for a certain period and calculates new statistical values, based on the aggregated data. The detailed data is discarded, and only the aggregated statistics stay in the database.

Database maintenance runs every day at a specified time, by default at 2.15 am, and it should not take longer than two hours. Depending on the data granularity and retention period, you may need to configure your database differently.

The more granularity and the longer the retention period, the larger the database.

Specify when the maintenance runs

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.


  5. Click Submit.

Database maintenance runs every day at the specified time.

Run Database Maintenance manually

When in doubt, run the maintenance manually.

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

Database maintenance runs immediately.

Find out how long the Database Maintenance takes

Database maintenance is a process that might affect the performance of your Orion Platform deployment.

By default, your database maintenance starts at 2.15 am. For a healthy SQL server, it should run for 5 - 30 minutes.

If the database maintenance runs longer than two hours, investigate the tables with long maintenance times.

The database maintenance running longer than six hours or not completing at all indicates major issues in your deployment and results in performance issues.

  1. Open the swdebugMaintenance.log at C:\ProgramData\Solarwinds\Logs\Orion\swdebugMaintenance.log.
  2. Review the timestamp at the top to find out when the maintenance started.
  3. Scroll down and review the timestamp when the maintenance finished, and calculate how long the maintenance took.
  4. If the maintenance took more than two hours, skim the timestamps to investigate for which table the maintenance took long to complete.
  5. When you have identified the table with issues, consider troubleshooting the elements that store data in the table.
Last modified