Introduction to Performance Tuning Analysis Services 2008

So you've gone to all the trouble of building a cube, and your users are complaining that their queries are still too slow? This session will show you how to tune query performance on Analysis Services 2008, looking at partitioning, designing aggregations and identifying MDX-related bottlenecks.

Chris Webb

Chris Webb is an independent consultant specialising in Analysis Services and the MDX query language. He is a co-author of "Expert Cube Development with SQL Server 2008 Analysis Services", and the second edition of "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase". Chris has extensive experience of implementing Business Intelligence solutions on the Microsoft platform across a wide range of industries including pharmaceuticals, banking, engineering, manufacturing and market research.

Chris Webb's blog http://cwebbbi.spaces.live.com

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck .mdx .mdx MDX Demos

<< 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

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

Supercharge MDX performance using MDX Studio

Transaction Log Performance Tuning, Stop shouting Timber!