Monitor Analysis Services performance
Within the Relational SQL Server engine monitoring the performance is easy with pre-equipped tools such as Profiler, Database tuning advisor and Performance Monitor (SYSMON). How about for BI - Analysis Services monitoring in this case.
Again PERFMON (SYSMON) is helpful here and the SQL Server 2005 Analysis Services performance monitor counters and using Profiler too you can troubleshoot problems in Analysis Services by capturing events on a production system and replaying them on a test system. This approach is useful for testing or debugging purposes and lets users continue to use the production system without interference.
Take a look at SSAS Performance guide and SSAS server pro, also using the memory properties listed with the SSAS instance should give you more chance to optimize.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.