SQL Server Performance Forum – Threads Archive
Calculate time to execute MDX queryHow 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.