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


Solarwinds NPM 10.4 Upgrade

Upgraded our Solarwinds NPM from 10.3 to 10.4 with these steps for a problem-free install:

  1. Create solarwinds database backup on SQL server
    1. Login to SQL Management Studio -> Right-click SolarWindsOrion Database -> Tasks -> Backup
  2. Upgrade Solarwinds NPM server
    1. Log into Solarwinds NPM server as local administrator
    2. Extract 10.4 upgrade and right-click the NPM 10.4 install and select “Run as administrator”
    3. Run through the basic prompts and click finish
    4. The Configuration wizard will start up showing you your existing SQL server/login info (assuming you are using an external SQL server)
    5. Confirm on the final screen that the database will be upgraded and services installed and click finish

I was able to login after this with no problem and start using the new hardware monitoring features for network devices.  If you have any issues, I would first try shutting down all services with Orion Service Manager (under All Programs->Solarwinds Orion->Advanced Features) and then starting up all services.