July 29, 2010 at 11:11 pm
Due to the requirements on performance, I'm looking at splitting out Analysis Services onto its own server and Reporting Services onto its own server to help avoid any concurrency/memory issues with the Engine, Analysis Services and Reporting Services all running on the same server.
In the past, I've always placed them on the same server, so am wondering what's actually different and what needs to be considered when you split them out onto seperate servers. Any input would be greatly appreciated.
This will all be on SQL Server 2008 R2.
July 30, 2010 at 7:51 am
Hi James,
Forgive if I am stating something which you have already considered, but I would say that an important point here is licensing.
If you have all components installed on one server, then you need one single licence to cover them.
If you have the same components split across several servers, you will require a licence for each server - even if each server is only running a limited subset of components e.g. just reporting services, or just analysis services.
July 30, 2010 at 7:08 pm
Thanks for that Andy, yes I'm aware of that.
Basically needing to compare price v benefit of splitting them up, and performance is the obvious thing to point at I suppose.
Just struggling to find any online documentation about splitting them up across different servers. You aware of anything?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply