Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Disable Automatic Index Defragmentation

Disable Automatic Index Defragmentation

Created by Jousseff Jaranilla, last modified by Magdalena.Markova on Oct 23, 2017

Views: 1,425 Votes: 1 Revisions: 32

Updated: October 23, 2017

Overview

This article describes how you can disable automatic index defragmentation, using Settings in the Orion Web Console, or executing a SQL script on the SQL Server hosting your SolarWinds Database.

Environment

All Orion Core Versions

Steps

Orion Platform 2017.3 and later

  1. Log in to the Orion Web Console using an administrator account.
  2. Click Settings > All Settings > Polling Settings.
  3. Scroll down to Database Settings, and clear the Index Defragmentation box.

    image.png

    The index defragmentation does not run anymore.

Orion Platform 2017.1 and earlier

Make sure the account you're using has enough SQL Admin Privileges to make changes in your SolarWinds Orion Database.

  1. Log in to the server hosting your Orion Platform installation.
  2. Run the following query on the SolarWinds Orion Database:

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

    To run the query, use the Database Manager.

    1. Run the Database Manager.
    2. Right-click your SolarWinds Orion Database, and select New query.
    3. Paste the query to DISABLE Automatic Index Defragmentation.

    The index defragmentation does not run anymore.
     

Related Article: Enable Automatic Index Defragmentation

 

Last modified

Tags

Classifications

Public
/*]]>*/