Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am setting up a SharePoint 2010 on SQL 2012, and planning to use SQL 2012 Always-On cluster.

The cluster is established with 3 nodes with standard installs of SQL 2012 using AD accounts for services.

Whilst the cluster is running, I am unsure what to do with the SQL Server Analysis Services.

Currently I have two reporting service instances of SQL:

Default instance - Multidimensional and Data Mining analysis mode Tabular instance - Tabular analysis mode

Do I need to cluster the above services, and if so how do I go about this?

Appreciate any direction that can be given.

In case needed, I am referencing this post.

share|improve this question
1  
I've never heard of clustered Analysis Services, so my instinct would be... no, you probably don't. Then again, maybe you could see about having this migrated to the dba stack exchange site, where you're more likely to find a definitive answer. –  HopelessN00b Jul 24 '12 at 22:29

1 Answer 1

up vote 1 down vote accepted

To the best of my knowledge SSAS does not have an AlwaysOn equivalent. What you can do is set up an identical instance and replicate the SSAS data using an OLAP replicate task called from a SQL agent job on your clustered SQL instance.

Once that is in place you can set up a DNS alias that points to the main copy of the cube, then re-point the alias over to the replicated cube. The failover is manual but I don't know of a better way for a hot-hot set SSAS setup.

share|improve this answer
    
that makes sense, alternatively I think analysis services supports traditional active/passive failover as used in sql 2008 and before which is still available in sql 2012. That makes a clean separation and could even just install analysis services on a machine outside of the cluster should this be needed - as far as I can tell SharePoint powers pivot runs on a SharePoint server and is not reliant on the sql analysis services of a seperate server –  g18c Jul 26 '12 at 20:55
1  
SSAS is absolutely supported as an active/passive setup on a Windows cluster, since SQL 2005. Powerpivot is installed on one of the SP farm servers, and only relies on external SSAS/SSDS as far as consuming the data for Powerpivot databases. I think load balancing the Powerpivot instances on the SP layer is done automatically by SP if you have more than one SP server and Powerpivot instance, but I am not totally sure. –  Jason Cumberland Jul 27 '12 at 3:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.