Overview

This article provides comprehensive maintenance procedures for Windows Server Update Services (WSUS) to ensure optimal performance and prevent common issues such as patch failures, timeouts (exit code 340), and GetUpdates operation errors. 

Regular maintenance is essential for stable WSUS operations.

Common WSUS Issues

WSUS maintenance helps prevent and resolve issues such as:

• Patch failures and timeouts (e.g., exit code 340)
• GetUpdates operation timeout errors:

These issues are often caused by insufficient maintenance or improper WSUS configuration.

Basic Maintenance Operations

Before performing advanced maintenance, verify the following basic system requirements:

• Sufficient disk space availability
• Normal CPU consumption levels
• No memory leaks
• Network connectivity status
• WSUS specifications match the requirements outlined in Hardware and Software Specifications

WSUS Server Cleanup (Manual Method)

To perform manual WSUS cleanup using the built-in wizard:

1. Open the WSUS Administration Console.
2. Navigate to Options > Server Cleanup Wizard.
3. Select all cleanup options and proceed through the wizard.
4. Upon completion, review the summary for details on recovered disk space, then click Finish.

Recommended: Automating WSUS Cleanup

For consistent maintenance, automate WSUS cleanup using PowerShell and Task Scheduler.

Step 1: Create the PowerShell Script

1. Open Notepad and paste the following script (covers all cleanup tasks):

1. Save the file with the following specifications:
2. File Name:

• Save as type:

• Location:

Create the "Scripts" folder if it doesn't exist.

Step 2: Set Up Windows Task Scheduler

1. Open Task Scheduler ()

1. Click Action > Create Basic Task:
2. Name:

• Click Next
• Trigger (recommended):
• Select Weekly or Daily (weekly is sufficient for most environments)
• Click Next
• Action:
• Select Start a Program
• Click Next
• Configure the following values:

Click Next and then click Finish to save the task.

Step 3: Test Your Script

1. Right-click your new task in Task Scheduler and select Run
2. Monitor briefly to confirm it completes successfully

Advanced Maintenance: Database Reindexing

For large WSUS deployments experiencing performance issues, database reindexing may be necessary.

The SQL script performs the following maintenance tasks on SUSDB:

• Identifies and defragments fragmented indexes
• Sets fill factors for certain tables to improve insert performance
• Updates potentially out-of-date table statistics

Database Maintenance Procedure

1. Download the maintenance script: Maintenance Tasks on SUSDB.sql
2. Download and start Microsoft SQL Server Management Studio, then connect to the database instance where the WSUS database is running

2. Right-click on SUSDB and click on New Query.

3. Paste the script(copied from the attached Maintenance Tasks on SUSDB.sql) into the query box and click on Execute.

Wait while the request is being processed. Once the query is executed, the result is displayed under the messages tab

Database Size Reduction

To reduce the database size after maintenance:

1. From SSMS, right-click on the database SUSDB
2. Go to Tasks -> Shrink and click on Database

Click OK to start the database reduction.

Once optimization is complete, the window closes automatically.