question

JustinDietz-9589 avatar image
0 Votes"
JustinDietz-9589 asked ·

New SCCM build SQL question

I have managed 2 different SCCM environments in my career.

1 had a Primary, 3 MP/DPs. and a traditional SQL failover cluster. All Virtual

The other i built for a much smaller env. So everything including SQL was all on 1 physical host.



I am now building a new env for my new company. It will all be virtualized. My question is mostly about SQL.

Anyone using AOAG? is WSUS finally support with AOAG? Is there really a benefit to using an AOAG with SCCM over just a traditional failover cluster? Does anyone in a virtualized env put the SQL DB on the same as their primary....so no cluster at all?

I'll be managing about 1500 windows servers initially, and eventually the desktops too which will be maybe 15,000-20,000 .

sql-server-generalmem-cm-generalmem-cm-site-deployment
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered ·

Hi, @JustinDietz-9589
Thank you for posting in Microsoft Q&A forum.

Configuration Manager supports only the site database in an availability group, WSUS database is not supported by Configuration Manager in an availability group.
Here is the reference:
https://docs.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/sql-server-alwayson-for-a-highly-available-site-database#configuration-manager-supports-only-the-site-database-in-an-availability-group

We can use a SQL Server Always On failover cluster instance to host the Configuration Manager site database. Failover cluster instances provide failover support for the entire instance of SQL Server and improve the reliability of the site database. However, it doesn't provide additional processing or load-balancing benefits. Failover cluster instances require the use of shared storage, which can be a single point of failure. Degradation in performance can occur, because the site server must find the active node of the failover cluster instance before it connects to the site database.

To use failover cluster instance for the site database, the site database server must be remote from the site server. The cluster can't include the site server.


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 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for the response. I actually forgot about traditional failover cluster share disk....and how much of a pain that can be when virtualized.

If i have my 2 sql AOAG cluster nodes. My site DB would be in the aoag. Would i just have my WSUS and Reporting DB live on 1 of the nodes full time with no failover? I would like to keep all things SCCM on this one cluster.

When it came to my question of SQL on the primary site server i was not talking about a cluster. I was more asking if anyone has just spec'd out the site server to put the SQL server right on it. So single point of failure yes, but I was wondering if there were any benefits. I would be able to get a snap backup of the server nightly.

0 Votes 0 ·

> Would i just have my WSUS and Reporting DB live on 1 of the nodes full time with no failover?
Here is a guidance about moving the WSUS database to SQL Always On for your reference:
https://techcommunity.microsoft.com/t5/device-management-in-microsoft/moving-the-wsus-database-to-sql-always-on/ba-p/377239

0 Votes 0 ·