question

abhrfh-8495 avatar image
0 Votes"
abhrfh-8495 asked CarrinWu-MSFT edited

SQL server 2016 Analysis Services high availability

hi. I need to HA my current sql server SSAS node. I am using multidimensional SSAS.
Is there any documentation on this?

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dgosbell avatar image
0 Votes"
dgosbell answered

Yes, there is documentation on this here: https://docs.microsoft.com/en-us/analysis-services/instances/high-availability-and-scalability-in-analysis-services?view=asallproducts-allversions?WT.mc_id=DP-MVP-35889

SSAS only supports Windows Server Failover Clusters (WSFC) for high availability.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @abhrfh-8495,

Welcome to Microsoft Q&A!

Please refer to Analysis Services with Always On Availability Groups to get the steps:

If you are using availability groups as your high availability solution, you can use a database in that group as a data source in an Analysis Services tabular or multidimensional solution. All of the following Analysis Services operations work as expected when using an availability database: processing or importing data, querying relational data directly (using ROLAP storage or DirectQuery mode), and writeback.

And you could download SSAS Failover Cluster document from this link.

Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.