Cannot stop WSUS server cleanup wizard

As per subject.

I have tried to cancel it, but the window popped up saying:

The Server Cleanup Wizard is stopping. In a few moments you will be sent to the results pane where you can see what has been cleaned. (OK button)

These few moments became now about 12 hours and I don't know what to do. I am afraid to kill this process as I have WSUS completely stuffed on my other server (different domain) and it has already taken me more than 2 weeks to sort it out and still there are no results. I cannot afford to have the same story on this server as there are 10 people working on it non-stop.

What can I do with this Wizard to stop it without damaging anything? It takes quite a lot of processor resources...

Kind regards,

Jay

jbodysAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gratex_ssdCommented:
Hi there Jay,

This can happen when (running R2 edition):
1, The SBS Monitoring / Reporting feature tries to generate morning performance report during the time WSUS cleanup wiz is running - reporting is fetching data and wsus is cleaning up data from the same database - it can cause timeouts
2, You haven't run the cleanup wizard for a long time (it's recommended to run it once a month) and you have really big DB
3, You haven't run any maintenance on the WSUS DB at all

Since you say it takes some of computer resources (disk and processor usage) I can guess it's still doing something.

However, if you don't want to wait any more, you can kill the wizard without worrying of damaging anything by killing the mmc.exe process.

Then, try the following:

Reindex your WSUS database by running this script
http://technet.microsoft.com/en-us/library/cc708594.aspx
It is always wise to re-index your database once every month.

OR

You can try running this cleanup script (recommended by WSUS folks themselves, includes also DB indexing  (source (a good read, anyhow - http://blogs.technet.com/sus/archive/2008/10/20/wsus-updates-page-times-out-while-trying-to-view-or-approve-updates.aspx)

http://www.codeplex.com/WSUS/Release/ProjectReleases.aspx?ReleaseId=17612

2, re-run the wizard when no scheduled generation of reports occurs.
3, re-run the wizard by selecting only one option at the time, and continuing with next option selected.

From my experience, normally the cleanup wizard finishes just under two hours (for a maintained DB)

Let me know if something helped and we can look into it further.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.