Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.
ASTrace (Exe) - 2012 Add files via upload Jan 12, 2017
ASTrace CS - 2014 Delete DesignTimeResolveAssemblyReferencesInput.cache Jan 12, 2017
ASTrace CS - 2016
How to Install and Use ASTrace (2012).docx

AS Trace

SQL Server ships with a tool called SQL Server Profiler that is able to capture trace events from a SQL Server Analysis Services and write those events to a SQL Server table. However, the Profiler GUI consumes unnecessary memory and processor power capturing the trace events and displaying them on the screen. For constant monitoring and logging, the ASTrace tool will capture a Profiler trace and write it to a SQL Server table without requiring a GUI. ASTrace also runs as a Windows service allowing it to restart automatically when the server reboots.

Alternatives to ASTrace include server side traces (and then loading those .trc files into SQL Server with a PowerShell script after the fact) and Xevents.

ASTrace is a great way to capture the text and duration of MDX queries, to log details about processing failures, and to troubleshoot SSAS issues such as locking.

ASTrace 2.0 adds the ability for one ASTrace service to capture events from multiple Analysis Services instances at once.

You can’t perform that action at this time.