15.8. Summary
In this chapter you first learned about the calculation model in Analysis Services, followed by the query execution architecture of Analysis Services. You learned about the various tools that can be used to investigate the performance of Analysis Services. The SQL Server Profiler and perfmon counters in particular are very valuable tools that can help you investigate performance bottlenecks. You then learned about various classes of problems that can contribute to slow queries, along with recommendations on how to solve these problems. Finally, you learned about important query optimization techniques and best practices that can help you fine-tune your MDX queries. After reading Chapters 14 and 15, upon hearing the very word performance, your head should swell with visions of highly performing, scalable systems, each optimized to fulfill its designated mission!
Get Professional Microsoft® SQL Server® Analysis Services 2008 with MDX 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.
