Share via

Change MaximumFileDownloaded on WSUS server with widDB

עידן טנקל 26 Reputation points
2020-12-17T18:42:57.973+00:00

Hey all,

We have an offline WSUS upstream server and a few replica servers.
We wanted to accelerate the download rate of files from the upstream server. We already have the wright definition to the BITS service (we changed the proper value in the registry), but we also wanted to change it in the SUSDB level.

We found out a proper value in the WSUSDB under tbConfigurationB Table - named MaxSimultanousFileDownloads, and we did manage to get it via powershell cmdlets, as follows:

$wsus = Get-WSUSServer -Name wsusserver -Port 443 -usessl
$db = $wsus.GetDatabaseConfiguration().CreateConnection()
$db.connect()
$result = $db.GetDataSet('select MaxSimultaniousFileDownload from tbConnectionB', [System.Data.CommandType]::Text)

How it is possible to edit this value and change MaxSimultaniousFileDownload ?
Can it done by powershell?

as I said, the motivation is to accelerate the download process

We are working with WidDB

Thanks!

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,628 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rita Hu -MSFT 9,661 Reputation points
    2020-12-18T05:59:56.25+00:00

    Hi 68666259,

    Thanks for your posting on Q&A.

    I have researched some related threads, but I didn't find a effective way to resolve this issue. In my opinion, the WID database is simple and convenient for us. But the performance is low. Perhaps the SQL database may be helpful. We could try the below link to migrate the WID batabase to the SQL Server database:
    https://learn.microsoft.com/en-us/windows-server/administration/windows-server-update-services/manage/wid-to-sql-migration

    This method may not be what you want. But it's the best solution to solve this issue right now.

    Thanks for your understanding and cooperation. Have a great weekend.

    Regards,
    Rita

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Rita Hu -MSFT 9,661 Reputation points
    2020-12-23T01:59:31.86+00:00

    Thanks for your reply and your hard working.

    Also I will try my best to search the better solution. If there are any updates, I will inform you in time.

    Thanks for your time and have a nice day.

    Regards,
    Rita

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. עידן טנקל 26 Reputation points
    2021-02-22T19:39:29.253+00:00

    Connect to SUSDB if it's installed on WID - run SQL managment studio (SSMS) as administrator and than
    connect to the following database (with windows auth when win user is administrator on the server)

    \.\pipe\MICROSOFT##WID\tsql\query

    Now you can run update query against the database

    Change download file rate by increasing number of simultaneous jobs allowed 

    update tbConfigurationB
MaxSimultaniousFileDownload = 10000

    update
    also possible with PS 

    #PS
$s = get-wsusserver -name sv1
$config = $s.getConfiguration()
$config.MaxSimultaniousFileDownlaoded = 10000
$config.BitsDownloadPriorityForeground = $true
$config.save()

    Increase also 

    HKLM\Software\Policies\Microsoft\Windows\BITS\MaxJobsPerMachine

    Verification - WSUS synchronization process with BITS relly became faster! 

    # cmd as administrator
bitsadmin /list /allusers /verbose

    Number of jobs increased from 10 (original limit) to around 200!

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.