Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Critical index fragmentation error displays in the Orion Web Console

Critical index fragmentation error displays in the Orion Web Console

Updated September 14th, 2016


The following error appears on the Orion Web Console:

  • Critical index defragmentation detected during database maintenance


  • Solarwinds Orion Core Products


A database maintenance task detects highly fragmented database indexes that significantly decrease your database performance.


Defragment your SolarWinds database index as required. 


The following procedures describe how to execute SQL commands to enable and disable automatic index defragmentation on an SQL database server hosting your SolarWinds database.


NOTE: Ensure that you have a backup of your database before making any changes to the database.

SolarWinds recommends scheduling automatic defragmentation jobs on your SolarWinds database to minimize database errors and improve database performance.

Configure automatic index defragmentation on your SQL Server Express database server

  1. Open the Database Manager.
  2. Click Add default server.
  3. Locate and expand your SolarWinds Orion database. 
  4. Right-click any table and select Query table.
  5. Execute the following query:

    UPDATE dbo.Settings SET CurrentValue = 1
    WHERE SettingID LIKE 'dbm-defragmentation-enabled%' 

    Automatic index defagmentation is configured on your SolarWinds database.

Configure automatic index defragmentation on your SQL Server database server

Perform the following steps on the SQL database server hosting your SolarWinds database:

  1. Log in to your SQL database server using an account with sysadmin privileges.
  2. Navigate to your Microsoft SQL Server directory and start SQL Server Management Studio.
  3. Log in to the SQL Server instance hosting your SolarWinds database.

    Ensure that you are accessing your SolarWinds database and not the master database. You cannot query the master database because it does not include a Settings table.

  4. Expand Databases > Your_SolarWinds_Database > Tables.
  5. Click New Query.
  6. Configure automatic index defragmentation on your SolarWinds database.
    1. To enable, enter the following query in the Query field: 

      UPDATE dbo.Settings SET CurrentValue = 1
      WHERE SettingID LIKE 'dbm-defragmentation-enabled%'

      To disable, enter the following query in the Query field:

      UPDATE dbo.Settings SET CurrentValue = 0
      WHERE SettingID LIKE 'dbm-defragmentation-enabled%'


  7. Click Execute.

    Automatic index defagmentation is configured on your SolarWinds database. 


* Running database maintenance manually or automatically runs at 2:15AM

All program -> SolarWinds Orion -> Advance features -> database maintenance 


Additional settings related to index defragmentation are listed in the Settings table. Each setting includes a SettingID beginning with dbm-defragmentation.

The Microsoft TechNet website includes additional information about defragmenting database indexes based on your SQL Server database software. 


Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.


Last modified