How to find long running queries?

Question

We are using SSAS and MOLAP. In SQL land, I know ways to query to get the longest running queries (see this SO question). It would be nice if we could do the same for our cube, get a list of long running MDX queries. Is this possible and what would this query look like?

Answer 1

You can use SQL Server Profiler to monitor SSAS performance. According to MSDN you can e.g. Monitor the performance of an instance of Analysis Services and Identify MDX statements that run slowly.

Here is some additional resources:

• Introduction to Using Profiler with SSAS 2008
• My Quick Guide to SSAS Query Tuning Part One