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.

Ask a question in the SQL Server Forums

Send Feedback