SQL Server Technical Case Study
Writers: Denny Lee, Kay Unkroth
Investigators: Denny Lee, Thomas Kejser
Contributors: James Podgorski, Richard Tkachuk, Mosha Pasumansky, Akshai Mirchandani, Edward Melomed, Jonathan Ehren, Mark Tameling, Mukesh Kumar
Technical Reviewers: Akshai Mirchandani, Kevin Cox, Nicolae Mogoreanu
Published: July 2010
Applies to: Microsoft® SQL Server® 2008 and SQL Server 2008 R2
Summary: This technical case study describes how the SQL Server® Customer Advisory Team (SQLCAT), in collaboration with SQL Server developers, tested and optimized a large Online Analytical Processing (OLAP) solution based on SQL Server 2008 Analysis Services by using the Relational OLAP (ROLAP) storage mode. The study examines ROLAP system requirements and usage scenarios, highlights advantages and disadvantages of ROLAP in comparison with Multidimensional OLAP (MOLAP), and evaluates various ROLAP-related data warehouse (DW) optimization techniques regarding their effectiveness and limitations.
This case study is for data warehouse architects, database administrators, and storage engineers, and assumes the audience is already familiar with the concepts of large-scale data warehouse designs for servers, storage subsystems, and databases. A high-level understanding of Analysis Services optimization techniques for cube processing and query performance is also helpful. Detailed information is available in the SQL Server 2008 Analysis Services Performance Guide at http://go.microsoft.com/fwlink/?LinkId=165486.
Continue reading: Analysis Services ROLAP for SQL Server Data Warehouses
Pingback from Analysis Services ROLAP for SQL Server Data Warehouses « Denny Lee
Denny Lee just posted the link for this paper on SSAS ROLAP on the SQL CAT blog: http://sqlcat.com/whitepapers
Lee,
Could you attach the correct link to the new whitepaper? The pasted link in this post refers to a whitepaper created on November 2008.
Thanks
Pedro, MVP, CBIP
Please click the bottom most link (after the "Continue reading") to download the Analysis Services ROLAP for SQL Server Data Warehouses.
Sorry but the link refers to a paper that I think already read before and it was published on 2008! and this post refers to a paper published on July 2010...
It's a new paper or the old one as it seems?
Thanks for you fast answer!
Pedro
It's definitely a new paper, please refer to the bottom - and you'll see:
Continue reading: Analysis Services ROLAP for SQL Server Data Warehouses.
This is a link to the paper itself.
Dear Lee!
I found it now! Thank you very mutch! Now I have it and i'll read it during the next days. ROLAP approach is interesting subject for me because I found some limitations in SSAS on this.
Regards,
www.pedrocgd.blogspot.com
Pingback from Pour les gros joueurs! « La BI ??a vous gagne!
Pingback from Analysis Services ROLAP for SQL Server Data Warehouses | Best Servers Directory
Great article ... one question Lee, do i need to create aggregations in ROLAP approach?
You do not need to create aggregations if you do not want. As noted in the paper, the best approach is to start without them to see what the performance is like. Create aggregations (e.g. indexed views) based on the queries that are slow, eh?!
Pingback from SSAS White Paper list - reading for "SSAS Maestro" program | Vidas Matelis Analysis Services Blog
Vidas Matelis összeállított egy egész jó listát azokról a dokumentumokról, amelyek szükségesek lehetnek
Pingback from OLAP – The Analysis tool