locked
SCCM 2012 Distrubution Database RRS feed

  • Question

  • Hi All,

    I am currently designing a system center 2012 SP1 Config Mgr primary site with 1 secondary site.  Currently, I am looking at the database storage requirements for 25,000 clients and believe the following is more than sufficient, based on 3MB per client.

    150GB Site database .mdf (Including WSUS and reporting services databases)

    75GB Site database .ldf

    60GB Temp DB

    35GB Temp DB log

    My question is I keep seeing reference to a "Distribution Database", which seems to be related to SQL Server Database replication.  Can anyone explain what this database is and why it would be required, as it is not listed in the hardware requirements from Microsoft http://technet.microsoft.com/en-gb/library/hh846235.aspx.

    Also, can anyone detail if up to 30GB is ok for the WSUS database, based on a client count of 25,000?  Essentially, I have assigned 100GB for sys center database, 30GB for WSUS DB, 5GB for reporting services DB and 15GB spare.

    Any help would be much appreciated.


    Regards PowerShell90

    Thursday, March 7, 2013 9:06 PM

Answers

  • My question is, do you think that placing this role on the MP is good from a performance and security standpoint, or should I be looking to place the app catalog and service point on a separate dedicated VM?

    Do you know when you have multiple application catalogs if this needs to be load balanced or clients get automatically assigned like MP's


    CM does not load-balance the App Catalog web site usage, so you'll need something to sit in the middle to handle any logic involving redirection to a location-aware App Catalog web site.

    For Multiple Application Catalogs and how selection works, take a look here: http://technet.microsoft.com/en-us/library/gg682067.aspx#BKMK_ComputerAgentDeviceSettings

    There's more info here: http://blogs.technet.com/b/configmgrteam/archive/2012/07/05/tips-and-tricks-for-deploying-the-application-catalog-in-system-center-2012-configuration-manager.aspx

    http://blogs.technet.com/b/configmgrteam/archive/2012/05/29/deploying-a-great-application-catalog-experience-for-system-center-2012-configuration-manager.aspx

    http://blogs.technet.com/b/configmgrteam/archive/2012/03/31/introducing-the-application-catalog-and-software-center-in-system-center-2012-configuration-manager.aspx

    Consider placing the App Catalog web site on your DP's instead since they will have IIS installed as well. Remember that the web site role is rated up to 10K of client (loading), that kind of usage could interfer with the MP's operations since it sits on top of IIS as well, or, depending on your hardware and Hierarchy configuration it may not be affected.

    Rob Marshall | UK | My Blog | WMUG | File CM12 Feedback | CM12 Docs | CM12 Release Notes

    • Marked as answer by PowerShell90 Thursday, March 14, 2013 8:56 PM
    Wednesday, March 13, 2013 11:11 AM
  • I'm not an expert of the DB size thing, but I think the install documents do a good job of laying it out.

    For the site systems, 50GB is overkill. The only site roles that need lots of space are the DP and SMP. Everything else is pretty minimal because none of them store any data.

    Separating out IIS was a standard practice in the server 2003 days but since 2008 there isn't even a built-in way to do it -- the methods I know of to do it are a hack at best in 2008, 2008 R2 or 2012 -- so no, I don't recommend separating it out.


    Jason | http://blog.configmgrftw.com

    • Marked as answer by PowerShell90 Tuesday, March 19, 2013 4:05 PM
    Tuesday, March 19, 2013 3:58 PM

All replies

  • This might help, too: http://blog.coretech.dk/kea/system-center-2012-configuration-manager-sql-recommendations/.
    The size of the WSUS database is not tied to the amount of clients to be managed.
    I've never heard the term of "distribution database" when it comes to ConfigMgr. Could you provide an example?

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

    Friday, March 8, 2013 7:44 AM
  • "Distribution Database", which seems to be related to SQL Server Database replication.

    Linked article is good sizing information, 5MB per client as it states, your figures look OK,

    Distribution Database, we'd come across this when setting up MP replica's in CM07 and utilising SQL Replication. SQL Replication was used in early CM12 Beta but now it's custom replication, the CM DB would be the repository for any replication meta-data now, as far as I know.


    Rob Marshall | UK | My Blog | WMUG | File CM12 Feedback | CM12 Docs | CM12 Release Notes

    Saturday, March 9, 2013 7:06 PM
  • Hi Torsten,

    Sorry for the late reply, but I have been on Holiday since Thursday.

    I think Rob's reply below details that this is no longer required, which is a relief as I had no understanding about this database or it's requirements.


    Regards PowerShell90

    Sunday, March 10, 2013 8:44 PM
  • Hi Rob,

    Interesting that the article states 5MB per client, I think Microsoft might be been a little conservative with 3MB per client in their sizing documentation.  I really appreciate your response.

    One further question if I may...

    Since SP1 has arrived I have had to change my plan slightly in regards to deploying the application catalog and service point.  Microsoft states that it is best practice to place these two roles on the same server when serving internal clients, so I had planned to follow this.  Also, they have stated that you can have multiple application catalog and service point roles, so I had planned to install these on my two management points, alongside the reporting point, which is also going to be placed on each MP for redundancy.  My question is, do you think that placing this role on the MP is good from a performance and security standpoint, or should I be looking to place the app catalog and service point on a separate dedicated VM?

    Each management point would have 2x Quad core mid range cpu, 24GB of ram to support MP, App Catalog, and reporting point.  It seemed a logical place to install these roles as I already require components of IIS for the MP and reporting services.

    Do you know when you have multiple application catalogs if this needs to be load balanced or clients get automatically assigned like MP's

    If you require any further info please let me know?  Any help would be much appreciated.


    Regards PowerShell90

    Sunday, March 10, 2013 9:04 PM
  • My question is, do you think that placing this role on the MP is good from a performance and security standpoint, or should I be looking to place the app catalog and service point on a separate dedicated VM?

    Do you know when you have multiple application catalogs if this needs to be load balanced or clients get automatically assigned like MP's


    CM does not load-balance the App Catalog web site usage, so you'll need something to sit in the middle to handle any logic involving redirection to a location-aware App Catalog web site.

    For Multiple Application Catalogs and how selection works, take a look here: http://technet.microsoft.com/en-us/library/gg682067.aspx#BKMK_ComputerAgentDeviceSettings

    There's more info here: http://blogs.technet.com/b/configmgrteam/archive/2012/07/05/tips-and-tricks-for-deploying-the-application-catalog-in-system-center-2012-configuration-manager.aspx

    http://blogs.technet.com/b/configmgrteam/archive/2012/05/29/deploying-a-great-application-catalog-experience-for-system-center-2012-configuration-manager.aspx

    http://blogs.technet.com/b/configmgrteam/archive/2012/03/31/introducing-the-application-catalog-and-software-center-in-system-center-2012-configuration-manager.aspx

    Consider placing the App Catalog web site on your DP's instead since they will have IIS installed as well. Remember that the web site role is rated up to 10K of client (loading), that kind of usage could interfer with the MP's operations since it sits on top of IIS as well, or, depending on your hardware and Hierarchy configuration it may not be affected.

    Rob Marshall | UK | My Blog | WMUG | File CM12 Feedback | CM12 Docs | CM12 Release Notes

    • Marked as answer by PowerShell90 Thursday, March 14, 2013 8:56 PM
    Wednesday, March 13, 2013 11:11 AM
  • Hi Rob,

    I think your suggestion of placing the App Catalog and service point on the distribution point is a good idea.  To be honest, I was concerned around the performance impact with placing this role on a management point which will be serving potentially 25,000 + clients.

    Thanks for providing me with the links to the documentation.  Your help is very much appreciated.


    Regards PowerShell90

    Thursday, March 14, 2013 8:56 PM
  • Hi Rob,

    I think your suggestion of placing the App Catalog and service point on the distribution point is a good idea.  To be honest, I was concerned around the performance impact with placing this role on a management point which will be serving potentially 25,000 + clients.

    Thanks for providing me with the links to the documentation.  Your help is very much appreciated.


    Regards PowerShell90


    Enjoy helping :-) Have fun

    Rob Marshall | UK | My Blog | WMUG | File CM12 Feedback | CM12 Docs | CM12 Release Notes

    Friday, March 15, 2013 10:51 AM
  • a management point which will be serving potentially 25,000 + clients.


    This exceeds a single MPs supported capacity: http://technet.microsoft.com/en-us/library/bb680869.aspx

    Jason | http://blog.configmgrftw.com

    Monday, March 18, 2013 1:05 AM
  • Hi Jason,

    Thanks for this information.

    I had not clearly defined what my plan is; I am supporting 25,000 clients using 2 MP's, which should be ok I think?


    Regards PowerShell90

    Tuesday, March 19, 2013 12:44 PM
  • Yep,  it jumped out at me and I just wanted to make sure you didn't miss that.

    Jason | http://blog.configmgrftw.com

    Tuesday, March 19, 2013 3:09 PM
  • Many Thanks Jason.

    Jason, if possible, can you help me with the following planning questions?

    I am planning to pre-create the site database ahead of installing CM2012.  I have planned the following for a remote SQL cluster.

    Database

    150GB Site DB .mdf 50% initial size with 1 % AutoGrowth and 90% Max Size

    75GB Site DB .ldf 50% intial size with 2% Autogrowth and 90% Max Size

    The database server configured to reserve at least 4GB for CM DB and 85 % maximum memory allocation.

    Do you see any problems with this?

    Site Systems Storage

    Also, on the site systems I have allocated 50GB for ConfigMgr installation for each role, including site server and MP.  in your opinion do you think this is sufficient?  Do you recommend seperating out IIS on to a seperate LUN on a SAN, where IIS is installed on a site system.

    Any help would be much appreciated.


    Regards PowerShell90


    • Edited by PowerShell90 Tuesday, March 19, 2013 3:20 PM Modified error
    Tuesday, March 19, 2013 3:19 PM
  • I'm not an expert of the DB size thing, but I think the install documents do a good job of laying it out.

    For the site systems, 50GB is overkill. The only site roles that need lots of space are the DP and SMP. Everything else is pretty minimal because none of them store any data.

    Separating out IIS was a standard practice in the server 2003 days but since 2008 there isn't even a built-in way to do it -- the methods I know of to do it are a hack at best in 2008, 2008 R2 or 2012 -- so no, I don't recommend separating it out.


    Jason | http://blog.configmgrftw.com

    • Marked as answer by PowerShell90 Tuesday, March 19, 2013 4:05 PM
    Tuesday, March 19, 2013 3:58 PM
  • Hi Jason,

    Thank you very much. 

    SCCM certainly seems to raise further questions the more I dig, but I have got say the documentation is a lot better than 2007.


    Regards PowerShell90

    Tuesday, March 19, 2013 4:05 PM