Press "Enter" to skip to content

SSAS HA

James Serra enumerates high availability options for SQL Server Analysis Services:

If you are looking at providing high availability (HA) for SSAS, here are 3 options:

  1. Install SSAS on a Windows Server Failover Cluster (WSFC)Here’s a good article. The main issue with this option is that SSAS isn’t cluster-aware, so if windows is “OK” but SSAS (the service) is hung, it won’t failover

Read on for the other options.