CODEWITHSUNDEEP
sqlsql-server-2008mdxsql-server-profilerssas-2008
Ahmed Tanvir
Ahmed Tanvir

Reputation: 197

Getting actual executin time/duration of MDX query

How can I get the actual execution time or actual duration taken by an MDX query to run? I am not interested for compiling, parsing, rendering results etc. I am only interested for the execution time.

In sql profiler, I get two columns one is duration and another one is CPU time. More over it shows in both two rows. One for "query subcube" and one for "query end" event class. Can you please explain how can I get the desired run time?

Upvotes: 0

Views: 657

Answers (1)

Rick
Rick

Reputation: 1755

I use MDX Studio. It was originally written by Mosha Pasumansky who was one of the original and main developers of AS.

Upvotes: 2

Related Questions