Top SSAS white papers
These are my favorite SSAS white papers released by Microsoft, with many from SQLCAT. I’ll keep this post updated with new versions of the white papers as well as new ones that come along that I find useful:
Analysis Services 2008 R2 Performance Guide
SQL Server 2008 R2 Analysis Services Operations Guide
Analysis Services ROLAP for SQL Server Data Warehouses
Analysis Services Distinct Count Optimization Using Solid State Devices
Analysis Services Processing Best Practices
Analysis Services 2005 Processing Architecture
Analysis Services Distinct Count Optimization
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
SQL Server 2005 Analysis Services (SSAS) Server Properties
Scale-Out Querying for Analysis Services with Read-Only Databases
Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
Analysis Services Query Performance Top 10 Best Practices
OLAP Design Best Practices for Analysis Services 2005
Microsoft EDW Architecture, Guidance and Deployment Best Practices
SQL Server Best Practices Article (Scale-Out Querying with Analysis Services)
Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework
Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices
Updating the list:
Analysis Services MOLAP
Performance Guide for SQL Server 2012 and 2014
Performance Tuning
of Tabular Models in SQL Server 2012 Analysis Services
Hardware Sizing a
Tabular Solution (SSAS 2012)