Search This Blog

Saturday, October 1, 2016

SOLVED: WSUS synchronization history loading takes long time

If you want to view the WSUS synchronization history, but it loads very long time, then you have to clear the WSUS synchronization history from database.
You can do it with following query

USE SUSDB 
GO 
DELETE FROM tbEventInstance WHERE EventNamespaceID = ‘2’ AND EVENTID IN (‘381’, ‘382’, ‘384’, ‘386’, ‘387’, ‘389’)

Note also that if you have internal database, then connection to DB is slightly different. See this article https://blogs.technet.microsoft.com/sus/2009/03/04/clearing-the-synchronization-history-in-the-wsus-console/ for more information.

1 comment:

  1. hi

    the steps from 5 to 8 of this procedure fixed the issue in my case : https://www.vdberge.com/kennisbank/howto-wsus-cleanup-shrink-a-wsus-database-susdb-to-almost-zero/

    hope this can help.

    saludos

    ReplyDelete