Forum Discussion
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.
Windows Server Update Services (WSUS) best practices - Configuration Manager | Microsoft Docs
Reindex the Windows Server Update Services (WSUS) database - Configuration Manager | Microsoft Docs
