The Solarwinds event log was giving me this error: "Indexes with fragmentation over 90% found during DB maintenance."
I found this Solarwinds article giving me the fix HERE, but unfortunately the command is slightly different than the one they posted (maybe NPM 10.4 changed the tables slightly). The command they have you paste in a SQL query is:
UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'
But having the % sign was giving me an error, so the updated command should be:
UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled'
Solarwinds does not give you a query to actually verify your work, but this sql query will show you that your CurrentValue = 1:
from dbo.Settings where SettingID = 'dbm-defragmentation-enabled'
**I'm using SQL Server 2008 installed on Windows Server 2008R2