Diagnosing performance issues
The practice of performance tuning can range from being simple to being very complex, but most issues are easy to resolve through effective design and by applying simple troubleshooting steps and techniques. Sometimes problems are obvious and can be resolved easily. In more challenging cases, we must consider the possible causes and then eliminate possibilities to discover the remaining options. Fortunately, in most models, performance issues can be addressed without extensive experimentation. If your models have large volumes of data, many tables, complex relationships, or layers of complex calculation logic, you have a higher likelihood of running into performance problems that you'll need to sort out.
Processing ...
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.
