hi. I need to HA my current sql server SSAS node. I am using multidimensional SSAS.
Is there any documentation on this?
hi. I need to HA my current sql server SSAS node. I am using multidimensional SSAS.
Is there any documentation on this?
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.
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.
6 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?