Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Storage Modes in SSAS 2008R2 (MOLAP, ROLAP, HOLAP and InMemory) Expand / Collapse
Author
Message
Posted Wednesday, May 29, 2013 11:54 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 8, 2014 4:25 AM
Points: 62, Visits: 114


Can anyone throw some light on Storage Modes in SSAS 2008R2 (MOLAP, ROLAP, HOLAP and InMemory).

I overall aware about the concept of Storage Modes but need to know from the experiance which one is better.

Thanks
Saurabh


Post #1458043
Posted Thursday, May 30, 2013 10:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:03 AM
Points: 1,353, Visits: 1,733
Default Storage mode is MOLAP.In this, data gets pulled from Relational DB and pushed to Analysis services after aggregations are created.It fetches only leaf level attributes. Super fast but consumes more memory and its not real time. But using proactive caching MOLAP can be made realtime.

ROLAP is slow but real time and data and aggregations(stored in indexed views) are stored in relation databases.

HOLAP: Aggregations are stored in Analysis services and leaf level data are stored in relational data. It is realtime and slow for leaf level data and fast for aggregations



“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Post #1458307
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse