A windows service / console application to create & subscribe to Analysis Services XEvents and save them on disk in JSON format.
Although it was created for Azure Analysis Services it also work well with SQL Server Analysis Services.
Usage info: https://devscopebi.wordpress.com/2017/07/20/azure-analysis-services-tracer-aka-azureastrace-exe/
-
Download \dist folder
-
Run 'setup.install.bat' with 'run as administrator'
-
Change the Analysis Services connection string on 'AzureASTrace.exe.config'
-
Start the Windows Service
-
Change the XEvent trace template - Optional
Simply execute AzureASTrace.exe
Trace events will be stored in the output folder (configurable) as JSONL files organized by Date and Event Type.
Use the Power BI Template to analyse the trace output files:
