locked
MP in DMZ needs SQL database replica or connects to primary server? RRS feed

  • Question

  • Hi,

    I am installing MP in DMZ for IBCM but not too certain to use database replica or use site database? Our DMZ is in another forest (e.g. Forest A) and our internal SCCM is in Forest B. Also, if I enable "Require the site server to initiate connections to this site system" option then what would be advantage of doing it on the site system that is in DMZ?

    Thanks

    Monday, February 23, 2015 4:57 PM

Answers

  • Using a replica offloads some of the work from the site DB to the MP. Thus, the MP role itself will be able to query its local copy of the data instead of having to query the site's DB. Of course, this SQL replica must still replicate data from the site's DB so you haven't really eliminated communication. Thus, using a SQL replica will eliminate the MP having to query the site DB thus reducing the amount (in terms of attempts, not actual data size) of traffic between the MP and site DB.

    The setting you mention has no effect on the MP role as it pertains to an MP either querying the site DB or SQL replication.


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Monday, February 23, 2015 6:19 PM

All replies

  • Using a replica offloads some of the work from the site DB to the MP. Thus, the MP role itself will be able to query its local copy of the data instead of having to query the site's DB. Of course, this SQL replica must still replicate data from the site's DB so you haven't really eliminated communication. Thus, using a SQL replica will eliminate the MP having to query the site DB thus reducing the amount (in terms of attempts, not actual data size) of traffic between the MP and site DB.

    The setting you mention has no effect on the MP role as it pertains to an MP either querying the site DB or SQL replication.


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Monday, February 23, 2015 6:19 PM
  • Is there any documentation available showing preferred method to setup MP in DMZ whether to use replica or use site DB?
    Monday, February 23, 2015 6:25 PM
  • No. The only real difference between the two as far as the DMZ scenario is concerned is the difference traffic pattern (as mentioned) and the reduced reliance on the site DB neither of which is generally significant in a DMZ scenario though.

    Jason | http://blog.configmgrftw.com | @jasonsandys

    Monday, February 23, 2015 7:32 PM