New SCCM build SQL question

Justin Dietz 1 Reputation point
2021-03-01T14:29:34.26+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,078 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenLiu-MSFT 41,691 Reputation points Microsoft Vendor
    2021-03-02T07:34:04.243+00:00

    Hi, @Justin Dietz
    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://learn.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.