SSAS-Info.com - Microsoft SQL Server Analysis Services (SSAS) 2005/2008 resource hub
SSAS News New MS Paper: Scale-Out Querying with Analysis Services Using SAN Snapshots
New MS Paper: Scale-Out Querying with Analysis Services Using SAN Snapshots
User Rating: / 0
PoorBest 
Wednesday, 12 September 2007 10:27

Writers: Carl Rabeler
Contributors: Eric Jacobsen, Ron Talmage, Jon Danskin
Technical Reviewers: Denny Lee, Eric Jacobsen, Nicholas Dritsas, Bill Plein

Microsoft released new paper Scale-Out Querying with Analysis Services Using SAN Snapshots.

This SQL Server Best Practices white paper describes the use of virtual copy SAN snapshots in a load-balanced scalable querying environment for Microsoft SQL ServerĀ 2005 Analysis Services to increase the number of concurrent queries to Analysis Services servers with a rapid response time per query. Load-balanced querying distributes the load of all queries among the available servers. The use of the virtual copy SAN snapshots eliminates the need to copy data between an Analysis Services processing server and one or more dedicated Analysis Services query servers. This paper supplements the Scale-Out Querying with Analysis Services white paper.