SQL Server Performance Forum – Threads Archive

Calculate time to execute MDX query

How to get time taken by a MDX query to execute?
In QueryLog table Duration is in second. My query takes milliseconds to execute. So in duration field it is rounded to 0 second.

---

i think your question is related to AS2005.
In as2005 you can run profiler for analysis server and can get the time taken to execute.
Profiler shows the time in milliseconds.

---

I am using AS 2000.

---

]]>