THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Performance Tuning of #tabular models in Analysis Services 2012 #ssas

In the last weeks the Microsoft BI buzzword has been Power BI for Office 365, which will be available soon in preview. I read a few comments about the fact that there is a constant discussion about the future but a lack of information and discussion about what is really used and required today in the real world. I think it is a good news that Microsoft released the first important white paper about performance in Tabular: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services.

I suggest the reading of this white paper to all of you using Analysis Services Tabular and also to Power Pivot modelers. If you already have our SSAS Tabular book, you will find some more details in the white paper in many areas. And remember the repository we have for DAX Query Plan analysis on SQLBI: – we hopefully will add more content in the next months, after the DAX Query Plans white paper written by Alberto Ferrari.

The performance optimization in Analysis Services Tabular is a brand new topic: it’s different from the past, it’s not like SQL and it’s not like MDX. We still don’t have the right tools and the proper knowledge and experience written in books, but I think we’re on the right track to fill the gap.

Published Monday, August 5, 2013 3:37 PM by Marco Russo (SQLBI)


No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement