Chapter 11. Performance Tuning and Troubleshooting Tabular Models
This chapter will address the following topics:
- Understanding usability limits
- Optimizing and managing a model's design
- Diagnosing performance issues
- Using performance tools
- Investigating query performance with SQL Server Profiler
Introduction
This chapter will help you understand how to optimize a data model for performance and to utilize memory and other system resources effectively. The topic of performance tuning and troubleshooting is a little different than most of the other chapters you've read so far. So troubleshooting isn't a purely prescriptive exercise where you follow a set of steps with a predictable outcome. It is both an art and a science that often requires investigation ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
