Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.


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

Enable Automatic Index Defragmentation

Table of contents


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


This happens at 2:15 AM whenever the SolarWinds Database Maintenance is ran.


All Orion Platform product versions


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: 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
02:16, 19 Apr 2017