High Availability and MS Analysis Services/OLAP

Building business intelligence (BI) applications that utilize Microsoft SQL Server 2000 Analysis Services (MSAS) may be the most rapidly expanding area within SQL Server-based systems. Up until recently, OLAP applications were primarily developed with classic availability needs to support (5 days per week, 8 a.m. to 5 p.m. uptime requirements). However, in recent years, a higher and higher percentage of analysis services-based implementations have vaulted to near extreme availability requirements (to the point that many OLAP applications are now needed 24 hours a day, 365 days of the year). This is partly due to the improved decision capability that can be attained from OLAP applications (and with ...

Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.