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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial