Windows Server Update Services is configured by default not to create traffic peaks, which results in very slow download speeds. To change this behaviour, you must set the BitsDownloadPriorityForeground field in the tbConfigurationC table in the SUSDB database in True. This setting is described in the article Verifying WSUS Server Settings on Microsoft TechNet and examples of how to make changes to the KB922330.
You can make changes to the database manually by connecting to the database with any convenient tool or by using special tools.
- If you are using WSUS 2.0 with MSDE or WMSDE as the default database created during the WSUS installation process, use the command:
“%programfiles%\Update Services\tools\osql\osql.exe” -S %Computername%\WSUS -E -b -n -Q “USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1”
- If you have configured WSUS 2.0 to use an existing Microsoft SQL Server installation, use the command:
“%programfiles%\Update Services\tools\osql\osql.exe” -S %Computername% -E -b -n -Q “USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1”
- If you are using WSUS 3.0 with the Windows Internal Database created by default during the WSUS installation process, use the command:
“%programfiles%\Update Services\Setup\ExecuteSQL.exe” -S %Computername%\MICROSOFT##SSEE -d “SUSDB” -Q “update tbConfigurationC set BitsDownloadPriorityForeground=1”
- If you have configured WSUS 3.0 to use an existing Microsoft SQL Server installation, use the command:
“%programfiles%\Update Services\Setup\ExecuteSQL.exe” -S %Computername% -d “SUSDB” -Q “update tbConfigurationC set BitsDownloadPriorityForeground=1”