Network Management

How to identify and troubleshoot Database Maintenance issues with SolarWinds Platform (including known issues)

This article provides information on troubleshooting when database maintenance fails or does not complete as expected.

First published date

7/17/2019 6:05 PM

Last published date

2/13/2025 3:51 PM

Overview

About Orion Platform 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.

    Product section

    Orion Platform

    Resolution

    To identify the problem, please review the database maintenance logs:     

    • SolarWinds Platform:
      • C:\ProgramData\Solarwinds\Logs\Orion\SWDebugMaintenance.log                          
    • Diagnostics zip:
      • SolarwindsDiagnostics.zip\LogFiles\Orion\SWDebugMaintenance.csv

    Tips when reviewing Database Maintenance logs:

    • There should be be a daily log for each time database maintenance is ran.  If the failure happened on a specific day, review the corresponding log file.
    • Search for "ERROR" to find the problem stored procedure.  Once identified, search SolarWinds Knowledge Center for information how to resolve the issue.  If no information is found, please open a support case with the error message.
    • If database maintenace is completed, the following message will appear:

    INFO  SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete,  time elapsed: 658.356 sec.

      Known Database Maintenance issues in 2024.4: