locked
SCCM 2012 R2 - Offloading Management Point traffic from Primary RRS feed

  • Question

  • I am designing a SCCM 2012 environment. The design is to consist of One Primary site and 6 Distribution Points based in the same Data Center. Large remote sites will also recieve a DP server. For political reasons I will be offloading the Primary Database to a SQL Cluster.

    I am looking to reduce the load on the primary site server and increase resilancies in the environment, by offloading the SUP, MP and DP's from the primary server.

    I have read that one can completly remove Client MP traffic from the Primary by leveraging a DB Replica to be used by the offloaded MP.

    Questions:

    1. Does it make sence to use a DB Replica since the Primary DB is already off the Primary in a SQL Cluster?

    2. Is it possible to create a DB replica of a SCCM Database hosted in a SQL Cluster?

    3. If I install the MP on a remote system server, but point it to the Primary site database. Does this mean all MP load still goes through the Primary Site?

    Thanks in Advance.

    Tuesday, November 5, 2013 12:28 PM

Answers

  • 1. for a large number of clients yes, it still makes sense. Note that moving the MP remote removes the load from the primary site server and not the SQL replica. The SQL replica reduces the load on the SQL server. So, using a SQL replica for the MP does both things and yes, both things make sense with a lot of clients. Note that you will need at least two MPs as one MP only supports 25,000 clients. For 50,000, I would use at least three to provide HA and scalability.

    2. No. The SQL instance must be local on the remote MP.

    3. No, see #1. Don't confuse the MP and DB.


    Jason | http://blog.configmgrftw.com

    Tuesday, November 5, 2013 2:12 PM
  • I went back to read the documentation (http://technet.microsoft.com/en-us/library/hh846234.aspx) and it looks like I was wrong on #2 (I think this changed somewhere along the lines though as I'm pretty sure it used to be required). The SQL instance hosting the replica does not have to be local to the MP so I guess in theory you could run the replica on a separate failover cluster.

    Why would you do this though instead of hosting the SQL instance on the MP?

    Note that the replica is *not* a full replica; it is merely a small, partial replica with enough info for the MP to serve policy to clients.


    Jason | http://blog.configmgrftw.com

    • Marked as answer by Joyce L Wednesday, November 13, 2013 1:09 AM
    Tuesday, November 5, 2013 3:57 PM

All replies

  • How many clients are we talking about?

    Torsten Meringer | http://www.mssccmfaq.de

    Tuesday, November 5, 2013 12:50 PM
  • Initially 30,000 clients with possible future growth to 50,000
    Tuesday, November 5, 2013 1:01 PM
  • 1. for a large number of clients yes, it still makes sense. Note that moving the MP remote removes the load from the primary site server and not the SQL replica. The SQL replica reduces the load on the SQL server. So, using a SQL replica for the MP does both things and yes, both things make sense with a lot of clients. Note that you will need at least two MPs as one MP only supports 25,000 clients. For 50,000, I would use at least three to provide HA and scalability.

    2. No. The SQL instance must be local on the remote MP.

    3. No, see #1. Don't confuse the MP and DB.


    Jason | http://blog.configmgrftw.com

    Tuesday, November 5, 2013 2:12 PM
  • Thank you for the Reply.

    Can you clarify Answer 2.

    Q2. Is it possible to create a DB replica (to use with the Remote MP) of the Primary SCCM Database which is already hosted in a SQL Cluster?

    Tuesday, November 5, 2013 3:39 PM
  • I went back to read the documentation (http://technet.microsoft.com/en-us/library/hh846234.aspx) and it looks like I was wrong on #2 (I think this changed somewhere along the lines though as I'm pretty sure it used to be required). The SQL instance hosting the replica does not have to be local to the MP so I guess in theory you could run the replica on a separate failover cluster.

    Why would you do this though instead of hosting the SQL instance on the MP?

    Note that the replica is *not* a full replica; it is merely a small, partial replica with enough info for the MP to serve policy to clients.


    Jason | http://blog.configmgrftw.com

    • Marked as answer by Joyce L Wednesday, November 13, 2013 1:09 AM
    Tuesday, November 5, 2013 3:57 PM
  • Thanks Jason,

    I have not been clear enough in my question. I do not want to create a DB Replica in a SQL Cluster. I agree the best and simplest way to use a DB replica would be to host it on an SQL Instance on the MP Site Server.

    I want to create a Replica DB on the MP Site Server. (But the replica is of the Primary Site DB, which is in a SQL Cluster.)

    However, I have not been able to find any information on creating / setting up a DB replica of a Cluster Primary SQL Database. All the info I have is regarding creating a Replica of the Primary Site DB where the DB is local on the Primary server (And not on a SQL cluster, as in my case).

    Regards Paul.

    Tuesday, November 5, 2013 5:04 PM