SSAS Papers 
Analysis Services Query Performance Top 10 Best Practices
Analysis Services Query Performance Top 10 Best Practices
| Analysis Services Query Performance Top 10 Best Practices |
| Written by Carl Rabeler |
| Thursday, 07 June 2007 00:00 |
|
Proper cube design, efficient multidimensional expressions (MDX), and sufficient hardware resources are critical to optimal performance of MDX queries issued against a SQL Server 2005 Analysis Services instance. This article lists the ten most common best practices that the Microsoft SQL Server development team recommends with respect to optimizing Analysis Services query performance. |
Tags: mdx, must read, paper, performance
Latest Author Articles
- Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned
- Including Child Members Multiple Places in a Parent-Child Hierarchy
- Scale-Out Querying with Analysis Services Using SAN Snapshots
- Analysis Services Query Performance Top 10 Best Practices
- Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios (by
Top Rated
- MS Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
- SQL Server 2008 White Paper: Analysis Services Performance Guide
- Functionality & Performance Testing Analysis Services 2005 with Teradata v12
- Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
- Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
- MS Paper: 2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005
- Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows XP
- Why Local Cube Creation with ASSL is Superior to Local Cube Creation with the Create Global Cube Com
