Solarwinds 10.4 Indexes with Fragmentation

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:

Select *
from dbo.Settings where SettingID = ‘dbm-defragmentation-enabled’

**I’m using SQL Server 2008 installed on Windows Server 2008R2

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s