In this tutorial, I will explain how to maintain and optimize the installation of your WSUS service to keep it in optimal operating condition.
If your WSUS console shuts down regularly, I advise you to switch the database to SQL Server. For that you have two solutions:
- Migrate the existing database to SQL Server.
- Since Windows 2016, it is possible during installation to choose a SQL Server.
Reject replaced Updates
As the months pass, updates accumulate on the WSUS server and some updates are overwritten by others.
Keeping the updates replaced have no interest.
Replaced updates are now rejected and no longer shown to computers.
Clean unused files
Cleaning unused files will remove the files physically present on the server.
We will find in these files the replaced updates that were refused.
Reindexing the database
In order to maintain optimal database performance, it is necessary to reindex the database.
A script is available on the Technet website at this address : Scripts/Maintenance and optimization/WsusDBMaintenance.sql · master · RDR-IT / WSUS · GitLab (rdr-it.io)
If you are using the Windows internal database, you must install Microsoft SQL Server Management Studio on the WSUS server and use as server name :
\\.\pipe\Microsoft##WID\tsql\query using Windows authentication.
Wait while processing the request …
Reduce the size of the base
Once optimization is complete, the window closes automatically.
The tips differences in this article will help keep the WSUS services in an operational state.