We help IT Professionals succeed at work.

WSUS downstream replicas high CPU after deleting content folder and running wsusutil.exe reset

1,435 Views
Last Modified: 2014-08-04
We noticed that our WSUS content folder was growing out of control on the master and downstream replicas.  The decision was made to delete everything in the content folders on all WSUS servers and issue a wsusutil.exe RESET command on all WSUS servers as well as change every patch to UNAPPROVED on the master server.

Everything worked great and very quickly on the master which appears to be functioning fine but the downstream replicas are stuck.  The CPU is maxed on a core and WSUS is running queries indefinately.  There is absolutely nothing in the wsus content folder on these replica servers now and we have not approved a single patch after setting them all back to unapproved.  What is going on and how do I fix this?

Here is what is running in SQL on SUSDB:

SUSDB.dbo.spResetStateMachineAndReEvaluate;1  This query is running

SUSDB.dbo.spGetRevisionInfo;1 This query is blocked by the first one

SUSDB.dbo.spGetRevisionIdListForCache;1 This query is blocked by the first one

The downstream replicas are also not able to sync with the master while this is going on now.

How do I fix the downstream replicas so they start syncing again and stop with the maxxed CPU and SUSDB queries running with all the locking?


We are running WSUS fully patched on 2008 R2 for both master and downstream servers.  The SUSDB is running on SQL 2008 R2 fully up to date not sql express or windows database.
Edited by davidb1234 2 hours 50 minutes ago
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
NBF

Author

Commented:
That is what I did.  I uninstalled and reinstalled.  It still wouldn't sync. it had an error about a dependent update.  I repointed the replicas to Microsoft and did a manual sync and then back to the master server and now it is working.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.