I believe that there's a particular large bank where a couple MVP's work that has over 100k and SQL is local.
________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Eric Morrison Sent: Sunday, August 04, 2013 5:17 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] CM12: SQL local or remote? If they have that primary's site code, then it's handling those systems. You'll need remote DPs and MPs anyway to handle that count. So yes, you'll need remote SQL if you're managing that many systems. You'll also need to look at the mp, dp, sup, and other roles to see what count they support. For example, you're going to need multiple MPs for that many systems to one site. I believe 25k is the supported count o'er mp. Sent from my Windows Phone ________________________________ From: Roland Janus<mailto:roland.ja...@hispeed.ch> Sent: 8/4/2013 4:44 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] CM12: SQL local or remote? I do have an opinion on this and I know what I want to do, but I also have a conflict with a statement from technet: “A child primary site that uses SQL Server installed on the same computer as the site server can support up to 50,000 clients. When you use SQL Server that is installed on a computer that is remote from the site server, the child primary site can support up to 100,000 clients.” We expect up-to 100’000 clients but that site server will not serve clients, all handled with local servers (MP-replica, SUP). The site server is basically doing processing and replication, that’s it. I like to avoid more servers, more points of failures, more things to manage, more complexity. Anyone doing local despite what technet says? Anyone had this question raised to MS and got kind of an agreement doing so? (That is kind of important…) PM me if you don’t want to go public? -Roland ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
