WSUS SQL Choose

CC yvan 21 Reputation points
2022-01-17T14:06:41.447+00:00

Hi everyone
I really need your help, thank in advance。 :)

I want deploy WSUS in multi-site, but i dont know how type SQL should I choose, MID or SQL server,

I will deploy one WSUS in HQ to sync with Microsoft and as upstream server (HQ have more than 300 windows servers), and deploy 3-5 WSUS in Branch offices (one office one WSUS, Fewer than one hundred servers )

How should I choose the SQL?

My plan is upstream server use SQL server, branch use MID, is this ok? or do you have any better suggestion?

Thanks again. :)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,584 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,030 questions
0 comments No comments
{count} votes

Accepted answer
  1. Limitless Technology 39,331 Reputation points
    2022-01-18T08:43:15.307+00:00

    Hello CCyvan,

    Unless you have a specific DB requirement and already have a SQL License there are little reasons to chose a SQL WSUS unless literally thousands of machines and dozens of sites (and in that case, usually SCCM is preferred). WID will be fine, it has a 254GB limitation and you will never hit that limit. The main reason to use SQL is for performance (especially as time goes on even running the cleanup util), better management tools, and having the database on a separate drive/datastore. If you have a SQL license, and you are comfortable with SQL queries and DB management, use that. If not, use WID.


    --If the reply is helpful, please Upvote and Accept as answer--

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful