WSUS Console - Very Slow load of Synchronization History

shockoMS 276 Reputation points
2021-09-27T14:10:55.57+00:00

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! :)

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,599 questions
0 comments No comments
{count} votes

Accepted answer
  1. Pierre-Luc Giguere 1,076 Reputation points
    2021-09-27T14:23:20.307+00:00

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Adam J. Marshall 9,121 Reputation points MVP
    2021-09-27T14:17:42.783+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments