Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Scale-Out Querying with Analysis Services Using SAN Snapshots

Brief Description
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.

On This Page

Quick Details
File Name:ScaleOutQueryingASUsingSANSnapshots.doc
Version:1
Date Published:9/12/2007
Language:English
Download Size:170 KB
Estimated Download Time: 1 min 56K

Overview

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.

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000; Windows Server 2003; Windows Vista; Windows XP
Windows 2000; Windows Server 2003; Windows Vista; Windows XP
Microsoft Word

 Top of page

Instructions

Click Save to save the document to your hard disk
Click Open to open the document immediately

 Top of page

 Top of page


© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement