Which Engine (Storage / Formula) causing MDX Performance Issue?

  Follow below mentioned steps: -Set Profiler with Query Begin and Query End Event, Run Profiler Trace and Execute MDX which you need to tune. -Stop Profiler trace and save trace to table in RDBM -What you need to do is run the following SQL query against the table in which you had saved Profiler Trace Select…

0

SSAS:Informative Links

  Links Related to Analysis Services:   SQL Server 2005 Analysis Services Tutorial http://msdn.microsoft.com/en-us/library/ms170208(SQL.90).aspx   Analysis Services 2005 Migration http://www.microsoft.com/technet/prodtechnol/sql/2005/asmigrtn.mspx   Analysis Services 2005 Performance White Paper http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc   SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services http://www.microsoft.com/downloads/details.aspx?FamilyID=975C5BB2-8207-4B4E-BE7C-06AC86E24C13&displaylang=en

0