June 26, 2012 at 9:34 pm
On this Microsoft web page http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx#High_availability under the Analysis Services section there is reference to High Availability being included in Enterprise, Business Intelligence and Standard editions, but there is no further explanation. In previous versions of SQL Server SSAS has not been cluster aware (except with some butchering of the environment). Has this changed in any way in SQL Server 2012? In particular is it possible to build 2 dedicated SSAS servers, and configure them for AOHA, then point your reports to the AG Listener and interrogate the cubes? Also will the cubes be maintained across the servers, even if they are on different drives (no SAN)?
I'm not much of a BI person, but from what I've seen so far this isn't possible. Has anyone looked into this?
Leo
Nothing in SQL Server is ever so complicated that with a little work it can't be made more complicated.
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
June 29, 2012 at 11:28 am
Business Intelligence Edition is just an Edition of SQL Server. That doesn't mean that the HA features listed are applicable to SSAS or any other BI component. When it says that Availability Groups are supported in BI Edition, it means for the database engine.
SSAS is clustering aware in SQL 2008 also, but you're much better off load balancing SSAS than clustering it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply