MECM/WSUS - SQL option collocate or remote SQL?

asked 2020-08-20T08:43:34.89+00:00
Anonymous

Hi All

Wanted to bounce my thoughts with fellow members.

I am about to embark on a mini project for a customer. It's for a small experiment and a new network and infrastructure environment will be created on-premises. Unfortunately for this piece of work cloud is not an option. So a Virtualisation environment, SAN, networking, firewalls will all be procured.

I need to build MECM to help deploy a gold image to approx. 100 workstations, there are 2 variances of laptops I need to consider. As its an experiment it also not going to grow. I also need to ensure patching is configured for both clients and the small server estate being built.

So my thoughts are to build a new VM with MECM 2006 with the SUP role for WSUS and then use the OSD techniques with TS to build the Windows 10 image using PXE.

They will be building a SQL server to host a database for a third party application. My question is as its such a small environment should I put SQL on the same standalone server which will host the Primary site MECM server and SUP or it is doing a lot already and I should move the SQL stuff to a remote SQL rather than collocate?

From reading the docs I understand some considerations need to be taken into account to host both WSUS and ConfigMgr DBs within SQL (difference instances?) but because the environment will be so small my personal preference would be to keep it on same box, easier for me to deploy and easier for the customer to manage.

The security of the environment is high due to the nature of the customer.

What would others recommend and what would your approach be?

Many thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,476 questions
No comments
{count} votes

3 answers

Sort by: Most helpful
  1. answered 2020-08-20T12:42:12.757+00:00
    Garth Jones 2,071 Reputation points

    Keep everything on the same server and use the same instance for both CM and WSUS.

    No comments

  2. answered 2020-08-21T06:07:27.34+00:00
    Rita Hu -MSFT 9,391 Reputation points

    Hi isotonicuk-8740,

    Thanks for your posting on Q&A.

    We can place the SQL Server on the site Server computer or a computer that is remote from the site server. Both are OK. For both structures, SQL Server has limited memory. Please refer to the following picture:
    19391-6.png

    In addition, here is a link for your reference:
    https://learn.microsoft.com/en-us/mem/configmgr/core/plan-design/configs/support-for-sql-server-versions

    In my opinion, there are different instances between the WSUS and SCCM. But we could place the different instances into the same SQL Server. Here is my environment for your reference:
    19401-5.png

    Please remember to MARK the answer if it is helpful.

    Regards,
    Rita

    No comments

  3. answered 2020-08-22T22:17:56.813+00:00
    Jason Sandys 30,881 Reputation points Microsoft Employee

    This is an older post that is still applicable in most scenarios and reinforces the answer from @GarthJones-0118.

    No comments