none
SQL needed and where to deploy RRS feed

  • Frage

  • I have a very simple question: for SCCM I am deploying a central server with five primary sites, likely around 40 secondary sites.  I know that on secondary sites and distribution points that you can use SQL Express, but do I need a full version of SQL for my central server and for each single primary site, or an I use one SQL server for both my central server and my primary sites?  Thanks in advance
    Dienstag, 30. Juni 2020 17:17

Alle Antworten

  • "central server with five primary sites, likely around 40 secondary sites."

    What you should have is a Primary site with 5 Secondary servers, branching down to 40 Distribution points or you can simply have 1 primary server and 40 Secondary is you really want it.  The Secondary server will install SQL Express which is all that is needed for the box.  Distribution points don't use SQL.  Only the Primary needs SQL installed.   

    If you have a Central sites (CAS) then you should be running over 175,000 devices.  Any less and your hierarchy doesn't appear to have been configured correctly.  A CAS requires Enterprise SQL which is very costly.

    https://docs.microsoft.com/en-us/mem/configmgr/core/plan-design/configs/size-and-scale-numbers


    http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com


    Dienstag, 30. Juni 2020 17:58
  • The Central Management site has been requested by the customer, the primary sites will be global and they've requested we set this up, they have a large number of devices.  Now my understanding is that distribution points were on the same level in the hierarchy and were the preferred method for deployment as opposed to setting up secondary sites.  Each of the secondaries will likely have their own collections of servers split in half, so that we an update half of our domain controllers and then stagger the deployment of the rest.  I apologize for the simple questions, I'm not an SCCM expert and this was dropped on me today.
    Dienstag, 30. Juni 2020 18:37
  • The Central Management site has been requested by the customer, the primary sites will be global and they've requested we set this up, they have a large number of devices.  Now my understanding is that distribution points were on the same level in the hierarchy and were the preferred method for deployment as opposed to setting up secondary sites.  Each of the secondaries will likely have their own collections of servers split in half, so that we an update half of our domain controllers and then stagger the deployment of the rest.  I apologize for the simple questions, I'm not an SCCM expert and this was dropped on me today.

    Err unless they have 150,000 computers they don't need a CAS. It is a HUGE mistake to add one when one is not needed. 

    If they have over 150,000 computers then you should hire a consultant to designed the environment as there is a lot more to it than a few DPs


    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Dienstag, 30. Juni 2020 18:44
    Moderator
  • So basically a standalone primary site with DPs?  Here is what we have so far, any guidance is appreciated.  There are 30 locations and they want them split up graphically, the left most (North America) is the basic idea.
    Dienstag, 30. Juni 2020 19:01
  • So basically a standalone primary site with DPs?  Here is what we have so far, any guidance is appreciated.  There are 30 locations and they want them split up graphically, the left most (North America) is the basic idea.

    Start by answering the question, how many computers in total. 

    Then understand how many computers are EACH site

    Then understand the bandwidth to EACH site.

    From there the design will start to take shape. 



    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Dienstag, 30. Juni 2020 19:06
    Moderator
  • That's the problem, I have SO MANY unknowns.  Now, we have 1600 servers.  Denmark has the most, with around 400 servers.  We're in right around 30 countries, and we do plan to consolidate some into a single site (such as combining Japan, China, and India into one site).

    I've no idea about bandwidth and that has been a major concern for me, but it has been raised to the client that this is needed information.

    Again, thank you, this was sprung on me today and I've not used SCCM in a very long time.

    Dienstag, 30. Juni 2020 19:14
  • That's the problem, I have SO MANY unknowns.  Now, we have 1600 servers.  Denmark has the most, with around 400 servers.  We're in right around 30 countries, and we do plan to consolidate some into a single site (such as combining Japan, China, and India into one site).

    I've no idea about bandwidth and that has been a major concern for me, but it has been raised to the client that this is needed information.

    Again, thank you, this was sprung on me today and I've not used SCCM in a very long time.

    Until you can answer these basic questions, there is no point in moving forward. You need these basic question, before you can even start the design. What about workstations? How are you going to manage them too? 

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Dienstag, 30. Juni 2020 19:18
    Moderator
  • No workstations, only servers.  I just need to get a ballpark design together, the customer is aware that this is just an idea for a layout, we need something simple yet scalable.  I'm assuming I should ditch the central management server in Denmark and replace it with a standalone Primary Site which then connects to all of our secondary sites, which would have DP installed on the secondary site by default (that's what I was reading)?

    Thanks again
    Dienstag, 30. Juni 2020 19:24
  • No workstations, only servers.  I just need to get a ballpark design together, the customer is aware that this is just an idea for a layout, we need something simple yet scalable.  I'm assuming I should ditch the central management server in Denmark and replace it with a standalone Primary Site which then connects to all of our secondary sites, which would have DP installed on the secondary site by default (that's what I was reading)?

    Thanks again

    With 1600 devices total, a single primary server with 1 to 3 DPs for everything is all you need. 

    But you are begging for trouble by not knowing more about both their environment and knowing exactly what they plan to do. 


    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Dienstag, 30. Juni 2020 20:19
    Moderator
  • Oh I know we're begging for trouble, that's why we worked our statement of work to basically tell them that without knowing these things their costs could skyrocket.  Let me ask, since they want this to be regional, would a single standalone primary work and then have DPs dedicated to geographic regions?  Do you see any problem with this?
    Dienstag, 30. Juni 2020 20:41
  • Oh also quick addendum, how many management points?  Other devices I need to make this happen?  Thanks again so much for your help.
    Dienstag, 30. Juni 2020 20:46
  • Oh I know we're begging for trouble, that's why we worked our statement of work to basically tell them that without knowing these things their costs could skyrocket.  Let me ask, since they want this to be regional, would a single standalone primary work and then have DPs dedicated to geographic regions?  Do you see any problem with this?
    To be honest, there isn't enough details to do a design (even a rough design) base on so little details. What I have given you works for the numbers, heck maybe even overkill. But as my consultant self, I would run away from this project. Actually, I would insist that they define their needs and we do an review of their environment before doing another else, otherwise it is a complete guessing game. 

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Dienstag, 30. Juni 2020 20:59
    Moderator
  • Hi,

    Thanks for your reply.

    Agree with Garth, insisting that they define their needs and we do an review of their environment before doing another else. 

    On the side of consulting, it is recommended that we could open the premier case to get better support.

    Thanks for your time.

    Best regards,
    Amanda You

    Please remember to mark the replies as answers if they help.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Mittwoch, 1. Juli 2020 08:57