MDX Script Performance Analyser

Updated Release: Release 0.2 (Sep 11, 2008)

furmangg — Fri, 12 Sep 2008 04:59:58 GMT

Release 0.2 is the first release that supports Analysis Services 2008. There is a separate EXE for AS2005 and AS2008.

The only other change in this release is running queries in a background thread so that the UI is more responsive to cancelling the execution midstream.

Released: Release 0.2 (Sep 11, 2008)

Fri, 12 Sep 2008 04:59:58 GMT

Source code checked in, #17464

furmangg — Fri, 12 Sep 2008 04:59:35 GMT

fixing assembly info

Updated Release: Release 0.2 (Sep 11, 2008)

furmangg — Fri, 12 Sep 2008 04:56:35 GMT

Source code checked in, #17463

furmangg — Fri, 12 Sep 2008 02:55:14 GMT

adding separate project file for AS2008

Updated Release: Release 0.2 (Sep 11, 2008)

furmangg — Fri, 12 Sep 2008 02:53:28 GMT

Released: Release 0.2 (Sep 11, 2008)

Fri, 12 Sep 2008 02:53:26 GMT

Created Release: Release 0.2 (Sep 11, 2008)

furmangg — Fri, 12 Sep 2008 02:51:46 GMT

New Post: Can't get chart after clicking run query

furmangg — Thu, 11 Sep 2008 16:44:43 GMT

It works for us. We're going to need some more info. Can you include any error messages you get or a screenshot? Does it work with the example seen on the homepage against Adventure Works?

New Post: Can't get chart after clicking run query

triaphoo — Thu, 11 Sep 2008 14:14:58 GMT

Chris,

I can't get the two charts after running query at run time. Do you know why it is?

Thanks,
Triaphoo

Source code checked in, #17380

furmangg — Thu, 11 Sep 2008 05:40:45 GMT

executions run in background thread so that app is more responsive to the user cancelling and viewing partial results

Source code checked in, #17376

furmangg — Thu, 11 Sep 2008 04:15:16 GMT

checking in source code to existing 0.1 Alpha release

UPDATED WIKI: Home

furmangg — Wed, 25 Apr 2007 21:37:27 GMT

MDX Script Performance Analyser

The MDX Script Performance Analyser allows the user to identify how much each calculated member, named set and scoped assignment in an Analysis Services cube's MDX script contributes to the overall performance of a given MDX query.

To use the tool, all you need to do is connect to the database and cube you'll be querying and then enter an MDX query in the main textbox and hit the 'Run Query' button. When you do this, the tool does the following:

Connects to the cube using ADOMD.Net and AMO
Read's the cube's MDX Script and splits it up into its constituent statements, storing them in an array
Executes a Clear Cache command to ensure that all queries are run on a cold cache
Executes a Clear Calculations command so that for the current session the cube appears as though its MDX Script contains no commands
For each statement in the array of statements from the MDX Script, it then:

Executes the first statement in the MDX Script within the session, so that the cube now acts as though its MDX Script contains only this statement and all previously executed statements
Runs the query you entered in the textbox
Stores how long the query took to run, plus other interesting metrics

Once the query has run on the equivalent of the entire MDX Script in the cube, a report is generated which contains graphs and charts illustrating the data captured earlier

Generally speaking, whenever you see a steep (and sustained) increase in the amount of time taken to run your query then you know that the accompanying MDX Script statement has had that effect and might be worth optimising.

For instance, look at the following screenshot and notice that the left graph spikes and sustains the increase:

Then you can move to the next page(s) of the report and find the MDX of the specific statement(s) in the calc script which are responsible for the slow performance. Download a sample report to see how this works.

RELEASED: 0.1 Alpha

Tue, 17 Apr 2007 07:00:00 GMT

This release is useable but still fairly rough around the edges.

UPDATED RELEASE: 0.1 Alpha

Tue, 17 Apr 2007 07:00:00 GMT

This release is useable but still fairly rough around the edges.

Source code checked in

cwebb — Tue, 03 Apr 2007 14:58:49 GMT

UPDATED WIKI: Home

cwebb — Tue, 03 Apr 2007 14:37:59 GMT

Connects to the cube using ADOMD.Net and AMO
Read's the cube's MDX Script and splits it up into its constituent statements, storing them in an array
Executes a Clear Cache command to ensure that all queries are run on a cold cache
Executes a Clear Calculations command so that for the current session the cube appears as though its MDX Script contains no commands
For each statement in the array of statements from the MDX Script, it then:

Executes the first statement in the MDX Script within the session, so that the cube now acts as though its MDX Script contains only this statement and all previously executed statements
Runs the query you entered in the textbox
Stores how long the query took to run, plus other interesting metrics

Once the query has run on the equivalent of the entire MDX Script in the cube, a report is generated which contains graphs and charts illustrating the data captured earlier