Creating Large-Scale, Highly Available OLAP Sites

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


    File Name:


    Date Published:


    File Size:

    499 KB

      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.
  • Supported Operating System

    Windows 2000, Windows Server 2003, Windows XP

      Microsoft Word XP or later
    • Download the file and open it using Microsoft Word.