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) > Enable Automatic Index Defragmentation

Enable Automatic Index Defragmentation

Table of contents

Overview

The following procedure executes the required SQL Command to enable automatic index defragmentation on the SQL Server hosting your SolarWinds Orion Database.

 

After enabling Index Defragmentation, this will happen at (default) 2:15 AM server time whenever the SolarWinds Database Maintenance is ran.

 

Environment

All Orion Platform product versions

Steps

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

  1. On your Windows Server, search for SQL Server Management Studio.
  2. Log in to your SQL Server Management Studio.
  3. Expand Databases.
  4. Right-click on your SolarWinds Orion Database.
  5. Select New Query.
  6. Paste the query below in order for you to ENABLE Automatic Index Defragmentation.

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

 

IMPORTANT NOTE:
1. If this is the first time you are turning on Index Defragmentation, it is recommended to increase the timeout for Index Fragmentation. Default is 3600s (1hr), Maximum is 50000s (~14hrs)
2. You can reset it to default after you have completed Database Maintenance (with Index Defragmentation turned on)

To increase to 50000s:

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

To set it back to the default:

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

 

IMPORTANT NOTE: Run the query below to check if Automatic Index Defragmentation is Enabled on the Database, and verify if the CurrentValue column has a value of 1 (1 = Enabled / 0 = Disabled). The table to check is [dbo].[IndexDefragmentationHistory].

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

 

 

Related MindTouch Article: Disable Automatic Index Defragmentation

 

Last modified
21:06, 23 Jul 2017

Tags

Classifications

Public