question

Max-8369 avatar image
0 Votes"
Max-8369 asked Max-8369 commented

"Error: Connection Error" viewing synchronization history on WSUS console (Windows Server 2019 and WID)

Dear professionals,

I have set up WSUS service at Windows Server 2019 VM with Windows Internal Database.
After running wizard and doing initial database synchronization, WSUS console occurs "Error: Connection Error" (System.Net.WebException - Timedout) when viewing the synchronization history page.

  • CPU : 6 v-cores of Xeon E-2278G

  • RAM:32GB

  • WsusPool setting is adjusted : Queue Length - 5000, Start Mode - Always Running, (CPU) Limit Interval - 10mins, Shutdown time limit - 180secs, Startup time limit - 180secs, private memory - 16000000 KB

  • WSUS Site is adjusted : connection time out - 600secs

  • WID's min server memory is set to 2048MB.

  • Running wsusdbmaintenance-sql is completed many times.

Do you have any idea to success viewing this page?

I wonder why is only the reference sync history so heavy?

Best Ragrards,
Max









windows-server-update-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AJTek-Adam-J-Marshall avatar image
1 Vote"
AJTek-Adam-J-Marshall answered Max-8369 commented

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

As you can see, WSUS Maintenance doesn't just include the SQL script and the Server Cleanup Wizard (SCW). There's more to it.

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Truncated SUSDB.dbo.tbEventInstance table today and re-indexed with wsusdbmaintenance-sql. So the timeout behavior has gone on viewing sync history.
Unfortunately synchronization history was gone together. And also viewing update program list occurs timeout that didn't happen until now.

0 Votes 0 ·
Max-8369 avatar image
1 Vote"
Max-8369 answered

Dear Adam,

Thank you very much for your advice.
I now set up WSUS service as reduced the choice of update classifications.
After attemption SUSDB.dbo.tbEventInstance table truncation, I'll report about this effects.

Max

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.