rasheedah

Thanks Kevin looks like your article is aligned to what a few SCCM MVPs said in an old forum discussion https://social.technet.microsoft.com/Forums/en-US/6bb8b527-b607-4c00-9ed0-69a94d7e6f59/sccm-cas-primary-site-server-same-sql-database-and-reporting-instance?forum=configmanagergeneral Just a matter of making sure SQL failover cluster server is optimized where there is a best practice documents http://www.hasmug.com/wp-content/uploads/2012/10/07-201210-Oct-SQL-Server-Optimization-and-Best-Practices-for-System-Center-Administrators-Kevin-Holman.pdf

I have a ticket open with MS thanks

Hi Garth, I was looking at a best practice document by MS from what i saw the CAS has a local sql and the Americas are using remote sql.. my now thinking is to go this route with primaries on the cluster using mulitple instance ...i really have not seen anything via technet other than MI's are supported ....btw client is on sccm 2012 r2 160k the focus right now is U.S.A. then address global sites later... correction there is one CAS/2 primaries 44k in one site and 32 in the other. I also saw active/active cluster not sure if this will work for a Hierarchy. I wished they kept local sql on all primaries believe me the discussion in regards to the advantage of this was beaten but the org wants HA of the site database...

I found my answer thanks!

Thank you for this is there an official MS document in regards to SCCM Hierarchy and sql configurations? So there will be one CAS/3 Primary Sites. It looks like Multiple Instance configuration is the way to go on a SQL Cluster. They will also be in one Datacenter FYI