Failover Clustering in Analysis Services

SQL Server 2008 Analysis Services (SSAS) natively supports Server Clusters (MSCS) in Windows Server. This enables you to design and implement highly available services in Analysis Services by using failover technologies. To better understand failover clustering technologies, see Server Clusters. Note that the concepts reviewed in that document also apply to Windows Server 2008.

Installing and Administering AS2008 clusters

See Getting Started with SQL Server 2008 Failover Clustering for a complete and detailed guide on installing and administering Analysis Services failover clusters.

General Considerations when using Failover Clustering

Failover clustering enables recovery from a service failure in the shortest time possible. However, it is important to note that:

  • When an instance fails over the next available node all connections are lost, with the corresponding loss of uncommitted work. Most client applications should be able to handle this situation; often, hitting the refresh button in the application will bring the results back.

  • Administrative applications that process Analysis Services objects should be designed to handle failover situations.