Report Portal

Configuring Proactive Caching in SQL Server

Proactive caching helps DBAs to better control the cube data automatic refresh frequency, offering near real-time data for reports. This article covers the settings for HOLAP and ROLAP, and configuring proactive caching.

Introduction

Mostly data warehousing and Business Intelligence (BI) applications work on historical data, which are normally refreshed on a daily, weekly or monthly basis. Although there are some near real time data warehousing and BI applications, their query performance is painfully slow. To help in this scenario, Analysis Services (Microsoft SQL Server 2005 and later versions) provides an amazing feature called "Proactive Caching". This new feature provides a query performance similar to that of historical data, with near real time data and minimal impact on the overall system. As a BI developer, you just need to configure proactive caching, and SQL Server Analysis Services (SSAS) will ensure you get performance of a fully processed data warehouse on near real time data.

Read more...

 

Tags: management, performance, rolap

 

2007-2015 VidasSoft Systems Inc.