WSUS Console - Very Slow load of Synchronization History

Question

Does anyone know how to speed up the load of the Synchronization history in the WSUS Console. even on Windows 2019 after running the community SUSDB maintenance scripts it takes minutes to load. Drives me nuts! :)

Answer 1

Hi,

We got rid of the problem by moving away from WID and migrate to SQL Server:

https://learn.microsoft.com/en-us/windows-server/administration/windows-server-update-services/manage/wid-to-sql-migration

We also used to delete older Sync history when it was on a Windows 2012 machine using this command

(warning, use at your own risks)

DELETE FROM tbEventInstance WHERE EventNamespaceID = ‘2’ AND EVENTID IN (‘381’, ‘382’, ‘384’, ‘386’, ‘387’, ‘389’) AND TimeAtServer < ’20yy-mm-dd

I wouldn't know the database path on Windows 2019.

Answer 2

This is due to the fact that NO maintenance procedures 'officially' take this sync history into consideration.

https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/

Connect to the WID - https://www.ajtek.ca/wsus/how-do-i-connect-to-the-windows-internal-database-wid/

The easiest way is to empty the table tbEventInstance, but that removes more than just the logs of Sync History (but it's safe to empty it)

WSUS Automated Maintenance (WAM) has the ability to customize how much sync history to keep, and remove the rest. Full disclosure: WAM is our product.