Search code examples
sql-serverssasolap

Catching queries from SSAS

I am looking for something like SQL Server Data Collection but for Analysis Services to log every executed OLAP query. As far as I know SSAS log doesn't provide this information.

Solution

  • You can use Profiler connected to SSAS to watch queries live.

    Or you can install ASTrace to log queries or any other trace events to a SQL database without a GUI running.

    Or you can use a server side trace to write to .trc files on disk on the SSAS server. Then you can later load those files to a SQL server database for analysis with a PowerShell script like this.

    Or you could use XEvents.