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

Posted on 2014-08-01
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
Question by:NBF
    LVL 17

    Accepted Solution

    The content folders will not fill up untill there are approved updates to download. In my experience once WSUS goes wrong its impossible to properly fix. Its much quicker to uninstall and reinstall.

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
    This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now