Could your cube processing use some acceleration? Do your ad-hoc SSAS queries perform slower than you would like? Let industry expert Adam Jorgensen, President of Pragmatic Works and SQL Server expert for over 15 years show you the best ways to troubleshoot, optimize and accelerate your SSAS queries. We will cover using all the SQL Server and Windows Server tools to dig in and find the problems with your SSAS processing and query performance. This session will cover:

1. Best design practices to avoid bottlenecks 2. Profiler techniques and Perfmon methodologies to find and resolve bottlenecks 3. Interpreting output and system behavior to point to root cause 4. Understanding the underlying SSAS architecture to help root our performance problems

This is a very interactive session with lots of discussion and live demos so come and learn with Adam and get your SSAS in gear while learning how to keep it in gear!

Speaker Bio: Adam Jorgensen, MBA, MCITP: BI has been delivering innovative SQL Server and Business Intelligence Solutions for over a decade. Adam is a SQL Server community pioneer as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups for BI and other organizations. Adam is a co-founder of BIDN.com (Business Intelligence Developer Network) and the co-host of SQLLunch.com, a weekly live presentation series focusing on combining experienced presenters with those getting into the community. He regularly speaks at industry group events, major conferences, Code Camps, and SQLSaturday events on strategic and technical topics.

Session Goal #1: Best design practices to avoid bottlenecks

Session Goal #2: Profiler techniques and Perfmon methodologies to find and resolve bottlenecks.

Session Goal #3: Interpreting output and system behavior to point to root cause and understanding the underlying SSAS architecture to help root our performance problems.

(Please note: cannont click through to speaker details from speaker's name below)