Friday, January 04, 2013 6:43 PM
In the MS TechNet Library for SCSM 2012, there's an article ( http://technet.microsoft.com/en-US/library/hh519675.aspx ) that describes how to layout the servers for either a 2 or 4 server scenario. They recommend using 2 servers in an evaluation environment and 4 in production. My question is more related to the recommended 4 server production environment. MS says to install a data warehouse database server along with a service manager database on two separate boxes, while the remaining two servers are reserved for the management servers. My question is why there's not a 3 server scenario where you can have one server running SQL server which would be used to host all the databases associated with the environment. This cuts down on a server and a SQL license.
Does anyone have any insight into that?
Saturday, January 05, 2013 10:13 AMModerator
You need to gives us some indication of the size of your deployment before we can adequately give advice but in general:
1) You won't save SQL licenses. SQL Standard is included as part of the System Center license as long as the SQL Server is dedicated to System Center. While there are advantages to using SQL Server Enterprise for the Analysis Services component (delta cube processing rather than complete cube processing every night), there are improvements in Service Manager 2012 SP1 that mitigate this to some extent.
2) Analysis Services and processing cubes can be a resource hog. Reporting likewise hits performance. If you are doing a lot of reporting and analysis then seperate the databases.
3) From 2), I would always suggest that the ServiceManager database should be seperate from the other Databases for performance reasons.
If you virtualise your environment then the additional server \ sql guest will not cost anything and you can tweak the resources allocated to each guest to fit in with your environment.