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 - Knowledgebase Articles > Database index fragmentation check in the Orion Web Console

Database index fragmentation check in the Orion Web Console

Updated February 4, 2019

Overview

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)

 

Environment

  • SolarWinds Orion Platform Products

Cause

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

Resolution

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.

    clipboard_e3909a462b9fcd6884029fce0053afc70.png

 

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

Tags

Classifications

Public