SSAS Events Analyzer is a simple monitoring system that can be easily applied to any SSAS server with a minimal effort.
The goals are the following:
- Monitor a production server with a minimal impact, collecting information about query and process
- Analyze data to locate most expensive queries
- Analyze data to detect increasing processing time
The initial focus is on Tabular models, but in reality the same technique can be applied to Multidimensional. You might want to add events in Multidimensional to analyze access to aggregations, but you should minimize the number of events logged in order to avoid slowing performance, so you might consider extending the events captured based on your specific requirements and workload.
You can download the scripts from the SSAS Events Analyzer project on GitHub.