none
Performance MDX, returing result to management studio

    Question

  • Hei!

    We have a simple MDX returning 16 000 rows.  When I look at the execution time in SQL Profiler, the MDX Query Begin to MDX Query End takes 1 second. But from starting execution of the MDX until til result is displayed in management studio, the total time is 4 second. So it seems that managements studio is taking 3 seconds to display the result. Is there any explanation for this?

    The same happens when running the MDX from openquery on the SQL server.

    When connecting to the cube from excel, returing the same result, the execution or render time seems much faster.

    /BF

    Monday, July 01, 2013 9:35 AM

Answers

  • Hi,

    That can be correct. SSAS sends a resultset consiting of XML to the client after it has finished the processing. It is probably the rendering time in MMS that adds more seconds. 16 000 rows is quite a large resultset.

    HTH

    Thomas Ivarsson

    Monday, July 01, 2013 5:30 PM
    Moderator