A Solution for Collecting Analysis Services Performance Data for Performance Analysis at  http://www.codeplex.com/SQLSrvAnalysisSrvcs

This codeplex solution automates the collection of SQL Server 2008 performance data from any or all of the following data sources ans stores the collected data into a single SQL Server 2008 relational database:

• SQL Server Profiler Analysis Services trace data
• Performance Monitor counters
• Analysis Services Dynamic Memory Views (DMVs)

This data is collected using an Analysis Services server-side trace, several Integration Services packages, a custom performance monitor collector in Management Data Warehouse, and Transact-SQL stored procedures. This codeplex project also include sample Reporting Services reports utilizing SQL Server stored procedures that correlate and analyze the collected data.These reports enable you to:

• Determine your slowest MDX queries for a specified time period
• Compare the performance of a specified query during different time periods
• Analyze a specific query to determine if it is storage engine or formula engine bound, to view the aggregations utilized, the number of subcubes and the number of partitions
• Analyze processing performance
• Correlate performance monitor counters with the execution of a specific query or processing operation
• Correlate DMVs with the execution of a specific query or processing operation

This solution was updated on 3/6/2009 and again on 3/31/2009 to:

• Consolidate all environment variables into a single script file - this dramatically simplifies installation and operation
• Fix bugs related to named instances - including, but not limited to the following - Performance Monitor counters for Analysis Services named instances must be entirely in capital letters in order to work in the Management Data Warehouse performance counter data collector.