SQL Server Performance

Calculate time to execute MDX query

Discussion in 'Analysis Services/Data Warehousing' started by bhavesh, Oct 11, 2006.

  1. bhavesh New Member

    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.
    bhavesh, Oct 11, 2006
    #2

  2. ranjitjain New Member

    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.
    ranjitjain, Oct 11, 2006
    #2

  3. bhavesh New Member

    I am using AS 2000.
    bhavesh, Oct 11, 2006
    #2

Share This Page