Network Management

How to verify that database maintenance is completing correctly in the Orion Platform

This article explains how to verify that the database maintenance task is completing correctly.

First published date

5/21/2019 4:45 PM

Last published date

5/5/2023 5:09 PM

Overview

This article explains how to verify that database maintenance  is completing correctly. 

Product section

Orion Platform

Resolution

  1. Navigate to the database maintenance logs on the Orion Server located at:

    C:\ProgramData\Solarwinds\Logs\Orion\

  2. Open the latest swdebugMaintenance.log log file in a text editor (such as Notepad). 
  3. Search for Database Maintenance Starting and Database Maintenance Complete.

    For example:

    2019-02-08 02:15:00,311 [1] INFO  DatabaseMaintenanceGui.Program - Database Maintenance Starting.
2019-02-08 02:39:22,297 [1] INFO  SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete,  time elapsed: 1461.497 sec
  4. Check the starting time and complete time values for unusually long task times. 
    The sample above shows 24 minutes, which is normal. If Database Maintenance shows Complete, it should be running normally.
If the Database Maintenance Complete line is not in the swdebugMaintenance.log file, check the swdebugMaintenanceExecutionHistory.log file. This will show the completion history for the maintenance even when the swdebugMaintenance.log file might not, and will look like the below:
  
2023-05-01 02:15:00,398 Database Maintenance Starting.
2023-05-01 02:15:42,484 Database Maintenance Complete,  time elapsed: 41.518 sec.
2023-05-02 02:15:00,347 Database Maintenance Starting.
2023-05-02 02:15:51,169 Database Maintenance Complete,  time elapsed: 50.323 sec.
2023-05-03 02:15:00,370 Database Maintenance Starting.
2023-05-03 02:15:50,494 Database Maintenance Complete,  time elapsed: 49.520 sec.