Forum Discussion
Solved
WSUS DB Maintenance
Is there a recommended maintenance script or set of tasks for WSUS on Windows Server 2019?
- Haven't done much with WSUS the last few years, but I liked https://github.com/awarre/Optimize-WsusServer
Haven't done much with WSUS the last few years, but I liked https://github.com/awarre/Optimize-WsusServer
Seems more holistic in the sense of looking at the WSUS app layer rather than pure DB layer.
- It does a lot.
Optimizing SQL or WID database (I recommend not to use the WID due to ram and CPU limits technically it's an unpatched SQL 2012 LocalDB,
WSUS,
IIS,
logging.
It also fixes the wrong OS names on database level as well as sufficiently compress and purge old updates from the database.
In typical environment this saves you thousands or hundred of thousands update metadata.
As said there's nothing better for WSUS DB than this. You won't be disappointed. Tried a lot of free scripted solutions before. WAM was once free too.
You will never have to worry about having too many Updates, old Updates, uneeded Updates. You can auto approve all and WAM takes care that the DB and repository doesn't explode.
Btw. For most customers I don't use WSUS to save any updates. As this does not make sense in modern environments due to delivery optimization.Microsoft provides extensive documentation on WSUS/SUP maintenance and optimization. It's free and supported.
https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/windows-server-update-services-best-practices
https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/reindex-the-wsus-database
https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/wsus-maintenance-guide
- Why should I bother? It's time consuming. The tool does everything of this plus more. The MS guides won't help you to overcome "by design" issues like OS naming, not being able to remove unneeded products from database or declining unneeded products. Either you make your own scripts or do this manually. This all is certainly more expensive than buying this little fee (imho).
