Are they moving to a remote dedicated server? Or do they want to drop it onto sql server resource that host multiple instances/dbs of other products? I offloaded a sql server to a dedicated virtual sql server, on the condition that there was a dedicated network link between the two endpoint virtual boxes, and it ran absolutely fine (14000 clients).
Main arguments are always licensing and iops. Show them a smsprov.log to highlight how much it talks to sql. And check out the guidelines for sql server from technet. Bear in mind you also need SSRS. Why not ask them to clarify the security issue that they perseve? From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: 12 March 2014 15:34 To: [email protected] Subject: [mssms] Moving SCCM 2012 DB Hi everyone, My DBA has asked me to move my local SQL install remote. I have a single primary site with 64 GB of memory and service only 1200 clients total. I see no reason to move the SQL to a remote location. They basically told me there reasoning was from a security standpoint. First reason was because local install required a local SQL instance (licensing), which we explained to them we are using STD edition and licensing is included. I need a strong business case to keep my SQL install local. I see no reason to move it off-box. Any suggestions? Thanks, Brian
