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...
Analysis Services Performance Tuning and Optimization Agenda for the second meeting of BI User Group, Feb 25 th Level : 300 Technology : Analysis Services 2005 / 2008 Description: Improving the performances of the Analysis Services is one of the main tasks of the DBA. In this session I will discuss the methodology for monitoring the Analysis Services server performances and how to analyze and resolve the performance bottlenecks. Identifying and resolving bottlenecks in most cases is a pretty complicated...