October 14, 2015 at 11:21 am
Curious what the industry standard is combining multiple instances on single server ?
Right now i have separate servers for OLTP, SSAS, and SSIS, and for OTP have Development, Test, and production environments. Im considering combining the SSIS and SSAS services into additional instances on each environment servers.
Now (Production)
OLTP
SSAS
SSIS
After
1 Server with 3 separate instances for SSAS, SSIS, OLTP. Then replicate this model through the environments to utilize development and testing.
October 14, 2015 at 5:10 pm
SQL Engine and SSAS can be installed in a multi-instance configuration. However SSIS can NOT, there can be only one! (sorry was channeling the Kurgan)
A lot of your question is tied to how hard each of these products "hit" the server. And a big part is how big of a box do you get for each. What kinds of disks? How split up? SAN?
SSIS itself doesn't take much memory, but a package using script tasks can use a lot. So there are a lot of questions tied to how your implementations use the machine.
Dev/QA machines tend to be smaller and performance is sacrificed for cost reasons. Prod machines tend to be more robust and broken out.
Then there is a cost position. When all those aspects of SQL are broken out you are required to have a license for EACH machine, so if you have SQL, SSIS, and SSAS on one machine you need one license, but if you have them broken out to three machines you need THREE licenses.
So the answer is, it depends..
CEWII
October 15, 2015 at 8:58 am
The BIG question is can a one box have enough resources for all that you want done... CPU AND Memory? Only you can determine that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply