Microsoft Download Center Archive

Creating Large-Scale, Highly Available OLAP Sites

  • Published:
  • Version: 1.0
  • Category: Document
  • Language: English

This paper introduces various techniques for creating large-scale, highly avalable OLAP sites.

This paper introduces various techniques needed to create large-scale, highly available online analytical processing (OLAP) sites using Microsoft® SQL Server™ 2000 Analysis Services and Network Load Balancing in a Microsoft Windows® 2000 Advanced Server infrastructure. High availability refers to the ability of a multiple-server site to withstand hardware or software outages that may affect individual servers within a site. A large-scale site is a site that has hundreds of gigabytes (GB) of data, making normal file copy operations ineffective.

This paper provides step-by-step instructions that demonstrate how to build the servers and the supporting infrastructure for a reference site based on both thin-client and thick-client architectures. The architectures described are designed to:

• Protect the data of a multiple-server OLAP site and keep the site up and running during unplanned outages.

• Coordinate the allocation of processing resources during planned outages, such as data refreshes and complex extraction, transformation, and loading (ETL) cycles.

• Solve many of the staging-to-production operational problems that can occur in large OLAP sites.

Files

Status: Deleted

This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to January 2015.

No files found

A file listing was not found in the Wayback Machine archives.

System Requirements

Operating Systems: Windows 2000, Windows Server 2003, Windows XP

Microsoft Word XP or later

Installation Instructions

Download the file and open it using Microsoft Word.

This page was generated from a snapshot of the Microsoft Download Center made on .
FamilyId: 9989a445-142b-4872-ac68-2b50f05228e2
Report a problem