i've got a question concerning the topology of SQL Servers in a enterprise. Until now we had a single SQL Server to serve the need of user databases throughout the enerprise.
Now were facing a change of our infastructure: The servers will be moved to a Hyper-V machine and we are going to install some application servers, that need SQL Server as backend: SharePoint, System Center Essentials, Data Protection Manager.
At least one, DPM, says it is to be designed to run on a dedicated server controlling its own SQL Server.
Now we think of giving each of this servers its own SQL Server. Is this a way to go? Or is it absolute nonsense? Should we try to force all the servers to use named instances on a single SQL Server? Sometimes i have the feeling that SQL Server becomes
a part of the OS, so just install it and let the application (SharePoint, DPM, you name it) take over control.
Any advice or opinion is highly appreciated.
View Complete Post