BI, Big Data, and Data Visualization

SQH03 SSAS 911 -The Field Medics Guide to Performance Tuning Analysis Services

11/21/2013

8:00am - 9:15am

Level: Advanced

Christopher Price

Senior Consultant

Microsoft

Is your cube causing you headache? Does it take way too long to process your cube? Are you losing sleep over queries or reports that run acceptably slow? Then this session is for you! This session uses field-tested techniques to demonstrate how you can use familiar tools to dig into Analysis Services processing and query handling to identify bottlenecks, isolate issues while understanding how and why they occur and what needs to be done to resolve or fix them.

You will learn:

  • Understand high-level MDX and Cube Processing process
  • How to use tools such as SQL Server Profiler, PerfMon and DB Tuning Advisor to identify SSAS performance issues
  • Techniques for isolating and resolving common cube issues