SQL Server Best Practices Article
Published: June 13, 2007Writers: Denny Lee, Nicholas DritsasContributors: Lubor Kollar, Lindsey Allen
This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers. Load-balanced querying ensures that readers of OLAP cubes can consistently query for the latest aggregations throughout the day and distribute the load of all queries among the available servers. This scale-out querying architecture optimizes cube processing time, increases the frequency of cube update, and makes processing more robust as you can afford more frequent processing and transparent error recovery.
For more information, please refer to the Scale-Out Querying with Analysis Services whitepaper.
You can also review the Scale-Out Querying with Analysis Services Using SAN Snapshots to provide scalability using a SAN. You can find more information at: sqlcat.com/.../scale-out-querying-with-analysis-services-using-san-snapshots.aspx
Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors
Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson
Pingback from Scale-Out Querying with Analysis Services…does it apply to SQL Server 2008 or 2008 R2? « Denny Lee
Hot on the heels of Thursday’s post on the virtualising of SharePoint 2010 , I thought I’d share with
Pingback from Tips and Resources for SQL 2008 R2 Virtualization « IT Core Blog
Here are this and some other articles on SSAS Load Balancing: