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.

Related Posts

Roll Your Own SSAS Performance Monitoring Tool

Shabnam Watson has a great post on building an Analysis Services performance monitoring tool from scratch using Power BI: In many cases, SSAS works efficiently with default settings right out of the box. However, when you have large databases, substantial number of concurrent users, insufficient resources on your server, or when best practices are not […]

Read More

BI Announcements At PASS Summit

Chris Webb points out some good news released at PASS Summit: Power BI Report Server There’s a new release of Power BI Report Server available, and you can read all about it here: https://powerbi.microsoft.com/en-us/blog/new-version-of-power-bi-report-server-now-available/ The blog post highlights the fact that you can connect to SSRS shared datasets via OData – which is basically what […]

Read More

Categories