The Analysis Services 2008 R2 Performance Guide is now available. In this 99-page long document contains information about building and tuning Analysis Services in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 cubes for the best possible performance. It is primarily aimed at business intelligence (BI) developers who are building a new cube from scratch or optimizing an existing cube for better performance. The goal of this guide is to provide you with the necessary background to understand...
Analysis Services Performance and Tuning - Thank you all for coming to my session Hello all First, thank a lot for coming to my lecture at the BI User group. For those of you who missed the training the agenda was: · The Analysis Services Health Check · Establishing performance baseline - Collecting Performance Monitor - Enabling OLAPQueryLog table - Running the Profiler - Processing Logging · Server Configuration · Best Practise Analyzer · Analyzing the performance baseline data - Analyzing Performance...
We can learn a lot about cube usage and actual aggregation usage from the OLAPQueryLog table. I attached here my demo from Tech Ready 6. In the attached file you can find a Word document which guides you what to do, T-SQL Scripts and SSRS reports. More details in a proper post when I'll be back from Seattle. Please let me know if you found a bug. Thanks, Itay Braun Premier Field Engineer - SQL Server Microsoft Services - UK E-Mail: itayb@microsoft.com Mobile: +44-796-928-9996 Blog: http://sqlblogcasts...