Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Critical index fragmentation error displays in the Orion Web Console

Critical index fragmentation error displays in the Orion Web Console

Updated September 14th, 2016

Overview

The following error appears on the Orion Web Console:

  • Critical index defragmentation detected during database maintenance

Environment

  • Solarwinds Orion Core Products

Cause

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

Resolution

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
03:53, 13 Apr 2017

Tags

Classifications

Public