WSUS Download Speeds

WSUS Download Speeds

Being on a metered internet connection I have to mind my downloads and also take opportunity to download as much as possible at the appropriate times, now being the time to download being the end of the month.

I kicked off my WSUS Sync and allowed the server to have access to the internet. The resulting data transfer was less than spectacular, averaging approximately 5-10 KBps.

Off to the googles with the following found: http://blogs.technet.com/b/msaad/archive/2010/09/24/increase-wsus-3-updates-download-speed.aspx

Command:
"%programfiles%\Update Services\Setup\ExecuteSQL.exe" -S %Computername%\MICROSOFT##SSEE -d "SUSDB" -Q "update tbConfigurationC set BitsDownloadPriorityForeground=1"

Not having the executable "%programfiles%\Update Services\Setup\ExecuteSQL.exe" and also running 2012 which uses MICROSOFT##WID, not SSEE I moved on.

Next I checked my BIT's settings (Computer Configuration -> Administrative Templates -> Network, Background Intelligent Transfer Service -> Limit the maximum network bandwidth for BITS background transfers) which were fine.

This fine post http://social.technet.microsoft.com/Forums/windowsserver/en-US/3b9df918-411c-44f8-a905-024ad0dcc2a7/windows-2012-wsus-service-bits?forum=winserverwsus showed me the light.

I opened up an administrative cmd window to my sql 2012 folder "D:\Program Files\Microsoft SQL Server\110\Tools\Binn"

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

Snip:

After running the above commands I cycled the WID and the WSUS servers, speeds ramped up to use the full bandwidth.

The first post was primarily correct, just not for Server 2012 R2 and requiring the mssql installed exe