Please open a support ticket and they can help you with a known database maintenance issue that some customers experience.
1 of 1 people found this helpful
I opened ticket 120756 "Database Maintenance - Runaway SQL Job" and received 4 SQL files to run against the database. I'm on the 3rd one now, and this one I'm told "takes hours". :-) Once this is done, I'll run the 4th and then I was told to re-run standard Orion maintenance.
Fingers are crossed!
How far along the maintenance task is? I solved this by asking an SQL guy to add few lines of code into the script. That code simply added a line of some text in some text file. By monitoring the size of the file I was able to track the progress. Not very elegant, but it provided the peace of mind I needed when maintenance was taking very long time: I knew that there is progress and that I won't wait forever.
Thanks for the suggestion. Can you find out what lines of code and what script? I'd like to try the same thing and I have direct access to manage the SQL database with SQL Server Management Studio.
From Solarwinds Support:
Go to: <installed drive>:\Program Files\Solarwinds\Orion
and open the file called:
Scroll all the way to the bottom and if you see "Database Maintenance Complete", then it finished.
I assume you should be able to "tail" the logfile to see how far along the maintenance is.