Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services
SQL Server Technical Article
Writer: John Sirmon, Greg Galloway (Artis Consulting), Cindy Gross, Karan Gulati
Technical Reviewer: Wayne Robertson, Srinivasan Turuvekere, Jeffrey Wang, Lisa Liu, Heidi Steen, Olivier Matrat
Technical Editor: Jeannine Takaki
Published: July 2013
Applies to: SQL Server 2012
Summary: Tabular models hosted in SQL Server 2012 Analysis Service provide a comparatively lightweight, easy to build and deploy solution for business intelligence. However, as you increase the data load, add more users, or run complex queries, you need to have a strategy for maintaining and tuning performance. This paper describes strategies and specific techniques for getting the best performance from your tabular models, including processing and partitioning strategies, DAX query tuning, and server tuning for specific workloads.
To review the document, please download the Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services Word document.