SQL Server Reporting Services & SQL Server Analysis Services Performance Troubleshooting
Some useful posts\white papers that you can't miss if you're looking on how to increase or troubleshoot performances of Analysis and Reporting server:
Analysis Services Processing Best Practices
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx#Profile
The recommendations in this white paper provide best practices for processing in Microsoft® SQL Server™ 2005 Analysis Services. These performance optimizations are based on real-world implementations with some of our top customers and partners who use SQL Server 2005 Analysis Services Enterprise Edition.
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
(New!!! 28 August 2007)
http://www.microsoft.com/downloads/details.aspx?FamilyId=975C5BB2-8207-4B4E-BE7C-06AC86E24C13&displaylang=en
This article provides the information about the available MDX query troubleshooting tools and demonstrates how to use the most common of these tools to identify and resolve MDX query performance bottlenecks with individual MDX queries
How to diagnose issues when running reports in the report server?
http://blogs.msdn.com/lukaszp/archive/2007/01/31/how-to-diagnose-issues-when-running-reports-in-the-report-server.aspx
Lukasz Pawlowski, Program Manager at Microsoft, discusses the process to follow when diagnosing issues when running reports in the report server
