Supercharge MDX performance using MDX Studio

MDX Studio provides unique visualization of MDX expressions and allows the user to interact with different stages of MDX execution. We all also be looking at behaviour or formula engine and storage engine in context of various queries and how MDX studio helps to peep under the hood and understand what is going wrong with the query.It is built by Mosha Pasumansky, who is inventor of MDX and one of the Architects of Microsoft Analysis Services.

Ashwani Roy

Ashwani Roy is SQL Server MVP and Senior Consultant with Information Management Group (IMGROUP), winners of the Microsoft Global Business Intelligence Partner of the Year award for the past four years. Ashwani has worked with SQL Server BI stack since 2003 and is Microsoft Certified IT Professional. His main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.

Ashwani Roy's blog http://ashwaniroy.spaces.live.com

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck

<< 1 >>

---

Other sessions from this conference

Denormalisation –having your cake and eating it.

Design patterns for SSIS Performance

Designing and Tuning high speed data loading

Event Driven Cube Performance and Security Monitoring

Fast Track Foundations: Get Serious about Sequential I/O

Getting Started with SQL Azure

High Availability in the Real World!

High performance functions

Improving Database Performance by Removing the Database

Inside the SQL Server Query Optimizer

Introduction to Performance Tuning Analysis Services 2008

Lessons Learned from 128 Core OLTP Testing

Make your DBA life better using SQL Server technologies - notes from field & best practices

Monitoring and Tuning Parallel Query Execution

Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory

Optimizing tempdb and temporary object use

Performance Management for SQL Server with SCOM 2007

Performance Monitoring & Tuning - Documented Tips & Tricks

Performance Troubleshooting made easy with PAL

Photograph: SQL Server Crash Dump Analysis

Scaleout scenarios with Service Broker

SQL Server 2008 Reporting Services Scalability and Performance

Transaction Log Performance Tuning, Stop shouting Timber!