The performance of Analysis Services is mainly measured in terms of how quickly you can execute MDX queries. However, if cube data becomes stale it may no longer be helpful to the decision makers. Optimal processing performance ensures timely availability of up-to-date data in a user-friendly, highly efficient format. You can monitor SSAS processing using Performance Monitor (PerfMon) as well as SQL Server Profiler. Processing performance is heavily dependent on how quickly you can query the relational data source objects, but SSAS hardware and other operations running concurrently could also introduce a bottleneck. There are some Analysis Services configuration options you could tweak to try to improve the processing performance. In this section, you will learn about PerfMon counters and SQL Server Profiler events useful for monitoring processing, as well as useful configuration options for troubleshooting processing issues.
You can launch PerfMon...