Windows 2022 WSUS DB Maintenance Issue

rr-4098 1,086 Reputation points
2024-03-29T15:17:23.31+00:00

We have the WSUS service running on a Windows 2022 server. Originally a team member reported the console crashed anytime they ticket off a sync or server cleanup. I connected to the WSUS DB and reindexed and defragged the DB which is ~90GB. I have tried to only select one option at a time in server cleanup but it hangs on Deleting unused \ superseded updates. I had the same result using PowerShell. I did going into the console and declined a bunch of updates but it had no impact on the cleanup process.

Thoughts...

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
815 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,030 questions
0 comments No comments
{count} votes

Accepted answer
  1. Adam J. Marshall 8,541 Reputation points MVP
    2024-03-31T02:09:55.6733333+00:00

    This is one of the exact reasons I created WSUS Automated Maintenance.

    There is much to do - it's not just as simple as running the re-indexing script (although it does help).

    Are you performing the proper WSUS maintenance including but not limited to declining superseded updates, running the Server Cleanup Wizard (SCW) (which you mention isn't working), running the SQL Indexing script, etc.? Did you optimize WSUS with Indexes, adjust IIS options? Have you done all of the maintenance documented by Microsoft?

    https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful