Sadly, Kim this is an argument that I seem to lose all the time, hence why I find myself on a project with 3,500 systems and a 4 SCCM server implementation From: [email protected] To: [email protected] Subject: RE: [mssms] SCCM2012: Local vs Remote SQL Date: Mon, 2 Dec 2013 19:02:22 +0000
Don't think there's official statements out there for one or the other on sub 50.000 sites. I'd go for the philosophical approach. "When I change a single point off failure into 2 single points of failure have I improved matters?" Sent from my Windows Phone From: Todd Hemsell Sent: 2/12/2013 19:25 To: [email protected] Subject: Re: [mssms] SCCM2012: Local vs Remote SQL great info, but not the question he asked... On Mon, Dec 2, 2013 at 11:50 AM, Trevor Sullivan <[email protected]> wrote: Ian, Local SQL is generally much easier to deal with, and can provide better performance if it’s configured correctly. Cheers, Trevor Sullivan From: [email protected] [mailto:[email protected]] On Behalf Of Hamilton, Ian A Sent: Monday, December 2, 2013 10:55 AM To: [email protected] Subject: [mssms] SCCM2012: Local vs Remote SQL Hi, Can anyone point me to an official Microsoft statement on the local vs remote SQL argument…? I’m arguing SQL should be local as less than 50,000 clients, I need more than TechNet forum posts and community blogs to back that up though. Any help would be appreciated. Thanks. ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com **********************************************************************
