CODEWITHSUNDEEP
sql-serverssasolap
Kulis
Kulis

Reputation: 1010

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.

Upvotes: 0

Views: 525

Answers (1)

GregGalloway
GregGalloway

Reputation: 11625

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.

Upvotes: 2

Related Questions