Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
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.
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