Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Enable Automatic Index Defragmentation

Enable Automatic Index Defragmentation

Updated: October 23, 2017 ​​​​​​

Overview

To defragment the SQL server hosting your SolarWinds Orion Database, enable automatic index defragmentation.

The Automatic Index Defragmentation runs at 2:15 AM server time (default setting), together with the SolarWinds Database Maintenance.

Environment

All Orion Platform product 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 select Index Defragmentation.

    image.png

    The index defragmentation now runs regularly with the specified timeout at the set time.

Orion Platform 2017.1 and earlier

Make sure that the account you're using has enough SQL Admin Privileges to make changes in your 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 = 1 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 ENABLE Automatic Index Defragmentation.

    The index defragmentation now runs regularly at the set time.
     

Increase the timeout for Index Fragmentation to 50,000 s

Run the following query:

UPDATE dbo.Settings SET CurrentValue = 50000 WHERE SettingID LIKE 'dbm-defragmentation-timeout%'

Set the timeout for Index Fragmentation to default

Run the following Query:

UPDATE dbo.Settings SET CurrentValue = 3600 WHERE SettingID LIKE 'dbm-defragmentation-timeout%'

Check that Automatic Defragmentation is enabled

Run the following query against the [dbo].[IndexDefragmentationHistory] table, and verify if the CurrentValue column has a value of 1 (1 = Enabled / 0 = Disabled):

SELECT * FROM dbo.Settings WHERE SettingID LIKE 'dbm-defragmentation-enabled%'

 

Related Article: Disable Automatic Index Defragmentation

 

SELECT * FROM dbo.Settings WHERE SettingID LIKE 'dbm-defragmentation-enabled%'

Last modified

Tags

Classifications

Public