SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

Scale-Out Querying with Analysis Services

SQL Server Best Practices Article

Published: June 13, 2007
Writers: Denny Lee, Nicholas Dritsas
Contributors: 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.

Figure 1 Analysis Services scale-out querying architecture

For more information, please refer to the Scale-Out Querying with Analysis Services whitepaper.

Published Dec 16 2007, 01:08 PM by denny.lee

Filed under: Analysis Services, Querying, Scalability

Comments

denny.lee said:

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

January 17, 2008 10:54 AM

About denny.lee

Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.