MDX Query Performance RRS feed

  • Question

  • Hi All,

    In production server if I execute some mdx query it's is very slow(2 cubes in the same server), the same cube if I detach and attach in some other free server and execute same query it is getting executed in seconds.. I mean it is very fast.

    I understand it is because production server is busy in processing other cubes.

    I still want to improve performance of this queries in production.

    I have new aggregation design to implement.. but implementing that and executing in new server will not give conclusion.

    Please suggest if any other way of improving performance of mdx queries.

    Thanks in advance,

    Monday, August 11, 2014 6:39 AM


All replies