Windows 2022 WSUS DB Maintenance Issue

Question

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...

Answer 1

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/