Analysis Services Query Analyzer

Last week a new, free tool for analysing the performance of MDX queries on SSAS Multidimensional was released: Analysis Services Query Analyzer. You can get all the details and download it here:

https://ssasqueryanalyzer.github.io/

…and here’s a post on LinkedIn by one of the authors, Francesco De Chirico, explaining why he decided to build it:

https://www.linkedin.com/pulse/asqa-10-released-francesco-de-chirico/

I’ve played around with it a bit and I’m very impressed – it’s a really sophisticated and powerful tool, and one I’m going to spend some time learning because I’m sure it will be very useful to me. It’s an AddIn for SQL Server Management Studio and captures Profiler and Perfmon data for an MDX query when you run it, does so for a cold and warm cache, and then displays the results in a variety of graphs and charts. And it even has an MDX formatter built in!

image

image

image

You can find a full list of features here, and when you download the tool it comes with very detailed documentation. Definitely a must-have for all serious SSAS Multidimensional developers.

11 responses

    • Hi Ibrahim,
      in the ASQA documentation (paragraph 1.4), Alberto and I explain why we decided not to support DAX queries (at least in this first version of ASQA). However, if we will receive a significant number of requests for this feature, we may consider the possibility of undertaking this new challenge as well.
      Regards
      Francesco

  1. Pingback: SSAS Query Analyzer – Curated SQL

  2. Pingback: Analysis Services Query Analyzer 1.0 – UGISS

  3. Hi Chris
    I am getting an error that saying MDX cue not found. Look over not seeing anywhere gives me a change connection option, Do you know how to fix it?

    • Hi Kate,
      could you kindly report the problem with more details to the ASQA support email address (ssasqueryanalyzer@gmail.com) or in the issues page of the ASQA Github project repository (https://github.com/SSASQueryAnalyzer/SSASQueryAnalyzer/issues)?
      We will take care of the problem as soon as possible
      Anyway, regarding the connection, ASQA MDX editor window has the same menu options of a standard SSMS MDX editor window plus the specific ASQA features. Hence you can change connection in the same way you do it in the standard SSMS MDX editor window (right click –> Connection –> Change Connection)
      Thank you

      Francesco

  4. Pingback: Analysis Services Query Analyzer - SSWUG.ORG

  5. Hi Chris,
    Thank you for this article. We use SQL profiler to investigate performance of a report (which can contain several mdx queries). Would it be possible to do the same in ASQA as well? I mean, run the report and produce a summary in ASQA with info regarding performance of each mdx query in the report?

    • Hi Dorota,
      the short answer is “no, you must execute a specific analysis for each MDX query.”
      This because, as stated in the ASQA documentation (in paragraph 2.1.2: “ASQA SSAS Assembly”), the ASQA SSAS Assembly is forced to manage only one analysis at a time. This makes perfect sense since two analyses running simultaneously on the same server would negatively influence each other and, consequently, the results of both would not be accurate.

      Francesco

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: