SSAS Events Analyzer is a simple monitoring system that can be easily applied to any SSAS server with minimal effort.

The goals are the following:

  1. Monitoring a production server with a minimal impact, collecting information about query and process
  2. Analyzing data to locate the most expensive queries
  3. Analyzing data to detect increases in 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 down the execution and lowering the performance; thus, you might consider extending the events captured based on your specific requirements and workload.

You can access the source code on the SSAS Events Analyzer project onĀ GitHub.