Let put it this way, for 400,000 computer Microsoft will NOT say if SQL should be local or remote. Which BTW, SQL is hosted locally on a site with 400,000 computers too. The Admins of that site are on this list too. ☺
Like John said no MVP will say that you should put SQL remote, Heck if I’m doing the install and SQL is remote, I add 15 days to the project due to all the headache that arise from remote SQL. Garth Jones Chief Architect www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:image004.png@01CD5E19.F3C3A110]<http://www.enhansoft.com/blog>[Description: Description: Description: Description: Description: Description: Description: cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Enhansoft's YouTube Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: Description: Description: Description: Description: Description: cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> Subscribe to Enhansoft’s Newsletter!<http://www.enhansoft.com/register> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Johns, Damon (DoJ) Sent: Wednesday, September 7, 2016 11:27 PM To: mssms@lists.myitforum.com Subject: [mssms] Configuration Manager Local SQL Best Practice Documentation Hi Everyone, Can anyone point me to the Microsoft TechNet documentation where they recommend that SQL be installed locally where a Primary Site has 50,000 clients or less? I’ve found a couple of blogs where people mentioned this but nothing specific from Microsoft. I’ve also found a number of blogs where MVP’s strongly recommend this, but again nothing from Microsoft directly or the Configuration Manager team. There must be something out there!? Cheers Damon ________________________________ CONFIDENTIALITY NOTICE AND DISCLAIMER The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.