January 27, 2010 at 8:11 am
I have minimal experience with SSRS and none with SSAS. I’m setting up a brand new SQL 2K8 environment and I’ve been looking for guidance, best practices, etc. on whether or not installing SSRS and SSAS on a separate server is the best way to go. My thinking is to set up a SQL 2K8 cluster for the Database Services and then install SSRS and SSAS on a separate stand-alone server in order to reduce resource contention. I also need to install SSIS and am wondering where the best place to install it would be. On the cluster or with SSRS and SSAS.
Some added information. This is to be a consolidated environment where multiple application's databases will reside on the cluster. Likewise their SSRS and SSAS components.
I appreciate any words of wisdom regarding the technical aspects of this type of configuration or direction to resources (i.e. white papers, etc.) that would help me make the best decision.
Regards,
Nerdmann
January 27, 2010 at 11:44 am
You might find the following articles/whitepapers useful -
Analysis Services Query Performance Top 10 Best Practices
Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications
Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned
The Analysis Services 2008 Performance Guide
In addition to the unique requirements specific to your implementation, other factors to consider - etl processes, high availability, kerberos authentication, storage model (rolap,holap,molap), etc.
Tommy
Follow @sqlscribeJanuary 28, 2010 at 6:22 am
The other thing to keep in mind is that you will need licenses for all the servers you are planning to install on.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 28, 2010 at 7:08 am
Thank you gentlemen. I really appreciate your input.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply