When you encounter
timeout errors while executing update services tasks, they are generally indicative of an unhealthy update server. The procedures in this article will help troubleshoot these errors and recommend ways to keep your update servers healthy.
Timeout issues are generally due to one or more of the following conditions:
- There is a high number of updates on the update server.
- There is a high number of approvals on the update server.
- The file system hosting the SUSDB database files is severely fragmented.
- The SUSDB database needs re-indexing.
Review the updates on the update server and remove approvals for superseded updates reported as 100% Not Applicable.
Create a custom view in the Patch Manager console for these types of updates
- In the left pane of the Patch Manager console, expand Enterprise > Update Services, and then expand your update server.
- Select Updates under the WSUS server that is having the issue.
- In the Actions pane (right), click New Update View.
- Under Step 1, the Select Properties window will open, select Updates have a specific approval and installation status.
- Under Step 2, edit the properties (click on an underlined value), and then define the properties:
- Click approved and needed.
- In the Approved State field, select Approved.
- In the Update Status field, select Installed/Not applicable.
- Click OK.
- Under Step 3, specify the update view name and description, enter a name and description for the new view.
- Click OK.
- Back in the main Patch Manager window, select the new view that you named in the left pane.
- Filter the view to show only updates with superseding updates:
- On the Has Superseding Updates column header, click the filter icon.
- Clear all of the check boxes except for Yes.
- Click OK.
- Enable the Not Applicable Percentage column:
- In the Actions pane, click Choose Columns.
- In the Column Chooser window, select the Not Applicable Percentage check box.
- Close the Column Chooser window.
- Sort the view by the new column in descending order.
After you create this view, remove the approvals for all of the updates with a Not Applicable Percentage equal to 100. Investigate the rest to determine why they are not also at 100%. This view should be as empty as possible.
Run the Server Cleanup Wizard
- In the left pane of the Patch Manager console, expand Enterprise > Update Services, and then select your update server.
- In the Actions pane (right), click Server Cleanup Wizard.
- Complete the wizard as appropriate for your environment.
Note: If you have never run the Server Cleanup Wizard, consider running it as a multi-pass event:
- Select Computers not contacting the server, Expired Updates, and Superseded Updates in the first pass. This should only take a few minutes even in the worst of conditions.
- Select Unused updates and update revisions in the second pass. Note: It is not uncommon for this pass to take several hours. We recommend you schedule this pass as an overnight task using Patch Manager. The task may timeout if run from the WSUS console, but it will not timeout if run as a Patch Manager scheduled task.
- Select Unneeded update files in the third pass. This may take several minutes, depending on the practical results of the first two passes and what files are actually eligible for deletion.
Stop the SUSDB database service on the update server
Run a disk defragmentation on the volume hosting the database files
Restart the database service and run a database reindex
Microsoft provides a documentation on this procedure in the following section of the WSUS Operations Guide: Reindex the WSUS Database.
Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.