May 24, 2010 at 12:45 am
Hi All,
I want to know, if SSIS and SSAS can exist on same server with SQL Server 2005/2008 engine.
I understand that the best practice is that they should be installed on different server but what are the disadvantages.
Any comments are appreciated.
Thanks
May 24, 2010 at 1:08 am
I would tend to say SSAS and SSRS should probably be on different servers as opposed to SSIS. I usually like to keep SSIS as close to the DB engine as possible. SSAS (depending on the cube type) only uses the DB engine during the cube build/refresh and then NEVER goes back to it.
A big disadvantage is licensing costs, you don't license SSAS, SSRS, SSIS, and the DB engine seperately, they are all in the same license. So if you put them on different servers you pay for as many servers as you use.
CEWII
May 24, 2010 at 6:50 am
the disadvantage of installing on different servers (other than cost) is the network traffic.
In these days of 64bit and multi GB RAM keeping them together makes more and more sense IMHO.
---------------------------------------------------------------------
May 25, 2010 at 2:42 am
SSIS and SSAS are normally kept together on the same server if you are using SSIS to access SSAS.
Are you really asking about Reporting Services (SSRS)?
If you are running on a 32-bit server, then trying to run the database engine, SSAS and SSRS on the same operating system will leave you with very little memory for each service. If you have a light workload then you should still get acceptable performance, but expect things to get very slow as the workload increases. Most people put SSRS and SSAS on separate servers in a 32-bit environment to allow each product to get enough memory.
In a 64-bit environment the normal option is to put all services on the same machine, and install enough memory so they can all work effectively. However if your workload is very heavy you may want to put the various SQL services on to separate servers.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply