We were experiencing hangs on the database maintenance procedures. This is a known bug, I just was going to document our repair... We are running NPM 9.5.1 on server 2003, sp2 with SQL 2005. Our database is approximately 20gig.
1) I renamed c:\Program Files\Solarwinds\Orion\Database-maint.exe so it would not run. (kludge, but it works.)
2) Ran a script provided by tech support that stopped all Solarwinds services and changed them to manual so they didn't restart during the repair.
3) Rebooted. (just cause I had an outage and love freshly booted systems.)
4) Ran the first script which is named newindexes.sql. This script ran without any errors and took 4 minutes.
5) Ran the second script which is named repairprimarykeys.sql. This script with errors (told to ignore) and took a few seconds.
6) Ran the third script and boom. As it turns out, this script, summarizewirelesshourly.sql, doesn't have a use statement at the top of it to specify the netperfmon table. You could either add the use statement to the top of the script of select the netperfmon table before running the script. It ran for approximately 1:10.
7) Ran the fourth script, summarizewirelessdaily.sql. This script is also missing the use statement to specify the netperfmon table. Fortunately, we were a bit smarter by this time and just selected that table before running. This script ran for just a few second.
8) Renamed Database-main.exe back to it's original name so it would run at it's appointed time.
9) Ran the script to restart all the services and change them back to automatic.
10) Let everything restart fully, then gracefully rebooted the server. (As I mentioned, I love a fresh reboot....)
11) After rebooting i kicked off the normal database_maint manually. We have been running for a few hours and it's still going, but I am hopeful.
More news after I finish.
