MDX Studio – Tool to Debug MDX


MDX Studio is a great tool developed by Mosha to help in tuning and debugging MDX. This is a Windows application which one can install in a PC / Windows Server.

There is a cut-down version of the tool online as well.

Some of the Features:

a) MDX Execution related Performance monitor values such as Storage Engine (SE) Queries, Memory Usage, Cache hits etc

b) Suggest Best Practice MDX after analysing the MDX

c) MDX visualisation using a Trace Tree

There is a detailed talk done by Ashwani Roy, in the URL below.  There is a slide deck and a video you can download from here.

http://sqlbits.com/Sessions/Event6/Supercharge_MDX_performance_using_MDX_Studio

Regards

Jegan

 

Advertisements

About EasyBIJegan

Business Intelligence Developer
This entry was posted in MDX, SSAS. Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s