solarwinds

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

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

• Login to SQL Management Studio -> Right-click SolarWindsOrion Database -> Tasks -> Backup

2. Upgrade Solarwinds NPM server

• Log into Solarwinds NPM server as local administrator
• Extract 10.4 upgrade and right-click the NPM