Submit a ticketCall us

WebinarVisual Monitoring Tactics: Getting More Log Search Value from SolarWinds Log & Event Manager with nDepth Webcast

Do things seem to make more sense when they are visualized? Are you an IT professional or security expert with a wish for more cybersecurity tools that provide an intuitive visual experience? Join Alexis Horn and Jamie Hynds from SolarWinds as they demonstrate how the nDepth feature in LEM can help make visualizing log search results a reality.

Register now.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Database index fragmentation check in the Orion Web Console

Database index fragmentation check in the Orion Web Console

Updated February 4, 2019


A  warning appears in your Orion Platform deployment:

  • "Database index fragmentation check"  (Orion Deployment Health page, Active Diagnostics)

    If the message says "Diagnostics timed out", it means that the Active Diagnostics test did not complete within the defined time range of 30s.

  • "Indexes with fragmentation over 90% found during DB maintenance." (Event)



  • SolarWinds Orion Platform Products


The Database Maintenance or Active Diagnostics detect highly fragmented database indexes that significantly decrease your database performance.


Make sure that Index Defragmentation is enabled, run Database Maintenance, and re-run the Active Diagnostics test.

If the Index Defragmentation is enabled, Database Maintenance runs index defragmentation.

  • SolarWinds recommends scheduling automatic defragmentation jobs on your SolarWinds database to minimize database errors and improve database performance.
  • Starting with Orion Platform 2017.3, Index Defragmentation is enabled by default on fresh installations. On upgraded instances you should enable it manually.
  • Ensure that you have a backup of your database before making any changes to the database.

Step 1: Ensure that index defragmentation is enabled in the Orion Web Console

  1. Log in to the Orion Web Console using an account with administrative privileges.
  2. Click Settings > All Settings > Polling Settings.
  3. Scroll down to Database Settings, and make sure Index Defragmentation is selected.



If the Index Defragmentation option is already enabled, run the "Check if Database Maintenance works properly" test. If the result is Error, review the related errors. Consult the issue with your DBA before you open a support case.

Step 2: Run the Database Maintenance

Index defragmentation, when enabled, runs as a part of the database maintenance.

By default, the Database Maintenance runs automatically at 2:15AM.

To run the maintenance immediately, start Database Maintenance in the SolarWinds Orion > Advanced Features program folder, and click Start.

Step 3: Re-run the test that reported the error

  1. In the Orion Web Console, click Settings > My Orion Deployment -> Deployment Health
  2. Find the "Database index fragmentation check" test and re-run it.

The issue should be resolved. If not, run the "Check if Database Maintenance works properly" test.

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