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 live online training, plus books, videos, and digital content from nearly 200 publishers.