我们可以设置BitsDownloadPriorityForeground=1来提高WSUS下载更新的速度:
如果你的WSUS是安装在server 2012或2012R2上的话:
1.下载和安装以下工具来连接WSUS数据库
Microsoft Command Line Utilities 11 for SQL Server:
https://www.microsoft.com/en-us/download/details.aspx?id=36433
ODBC driver 11 for SQL:
https://www.microsoft.com/en-us/download/details.aspx?id=36434
2. In CMD, 定位到 SQLCMD.exe的位置(具体位置查看你的安装路径):
cd C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn
3. 设置下载更新为Foreground mode:
SQLCMD.exe -S \\.\pipe\Microsoft##WID\tsql\query -d "SUSDB" -Q "update tbConfigurationC set BitsDownloadPriorityForeground=1"
转载于:https://blog.51cto.com/1344839/1926527