SQL Server 2008 Migration & Development

Session 2 – Optimizing OLAP Queries

Overview

Date: Wednesday, April 22, 2009

Time: 10:00am PT / 1:00pm ET

Duration: 90 minutes

Price: $149 USD

Training Format: Web Seminar

This session will cover how a query is being executed by Analysis Services. We will look at how we can use tools such as SQL Profiler to determine potential bottlenecks. We will also discuss solutions to common bottlenecks.

Outline

Understanding the query processor engine
Query execution analysis tools
Enhancing query performance
Getting started with query execution analysis
Storage engine bottlenecks and solutions
Formula engine bottlenecks and solutions

Audience

The target audience for this session is Analysis Services developers already familiar with SSAS development looking to understand how queries are being executed.

Other sessions for this workshop:

Migration to SQL Server 2008 (90 minutes)
Optimizing OLAP Processing (90 minutes)
OLAP Design Best Practices (90 minutes)