On the Solarwinds server:
Open Database Manager
Start > All Programs > Solarwinds Orion > Advanced Features > Database
Manager
Add default server
Expand your database and right-click on any table.
Execute Query.
Click on the “Enable table editing” button (Results can be edited)
Clear the existing query and enter the following:
UPDATE Settings SET CurrentValue = 1 WHERE SettingID LIKE ‘dbm-defragmentation-enabled%’
and click on Execute Query.
Run Database maintenance
Start > All Programs > SolarWinds Orion > Advanced Features > Database Maintenance, and then click Start.
