SQL Server Best Practices Article
Published: September 2007Writers: Carl RabelerContributors: Eric Jacobsen, Ron Talmage, Jon DanskinTechnical Reviewers: Denny Lee, Eric Jacobsen, Nicholas Dritsas, Bill Plein
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.
For more information, please refer to the Scale-Out Querying with Analysis Services Using SAN Snapshots whitepaper.
You can also review the Scale-Out Querying with Analysis Services to provide scalability by distributing your AS databases. You can find out more information at: sqlcat.com/.../scale-out-querying-with-analysis-services.aspx
Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors
Author: Carl Rabeler Reviewers: Mark Souza, Prem Mehra, Lindsey Allen, Mike Weiner, James Podgorski,
Pingback from Top 10 Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions | Developers Blog