Montag, 20. Juli 2015

NEXT: iWarp vs. RoCE Chelsio vs. Mellanox 10 GB/s

WSUS Download Speed to slow since 2012 R2 up to 10 times faster

During my POC I need to bring a up to date WSUS to my customer dedicated environments with no WAN connectivity.
Every time I set up a fresh WSUS I had to wait 3 days after 20 GByte were downloaded with 2 MBit/s  with a 100Mbit/s internet connection . That was and is to slow.

The reason is that the BITS configuration was changed from Microsoft. To speed up your WSUS Server you have to:

Install on your WSUS Server:

Microsoft SQL Server 2012 Native Client
Microsoft SQL Server 2012 Command Line Utilities

You can download them from here:
link

Then navigate to the new folder:
C:\Program Files\Microsoft SQL Server\110\Tools\Binn

Run administrative CMD:
SQLCMD.exe -S \\.\pipe\Microsoft##WID\tsql\query -d "SUSDB" -Q "update tbConfigurationC set BitsDownloadPriorityForeground=1"

or

.\SQLCMD.exe -S \\.\pipe\Microsoft##WID\tsql\query -d "SUSDB" -Q "update tbConfigurationC set BitsDownloadPriorityForeground=1"


Revert:
SQLCMD.exe -S \\.\pipe\Microsoft##WID\tsql\query -d "SUSDB" -Q "update tbConfigurationC set BitsDownloadPriorityForeground=0"