Analysis Services 2005/2008 ASTrace Utility Sample (Free)

The ASTrace utility provides you with ability to capture an Analysis Services trace and log it into a SQL Server table. The table can be queried later or read using SQL Server Profiler. The ASTrace utility runs as a Windows service that connects to Analysis Services, then creates a trace, and logs trace events into a SQL Server table using the SQL Server Profiler format. The ASTrace utility creates the trace using a standard trace template that you can author using SQL Server Profiler.

ASTrace is a lighter-weight approach and is recommended.

Scenario

Analysis Services does not have a built-in tool to extract traces and save them to a file or table. This ASTrace utility sample demonstrates how to implement that trace functionality.

ASTrace utility is part of Microsoft SQL Server Product Samples: Analysis Services project at codeplex. There is a version of this utility for Microsoft SQL Server Analysis Services 2005 and 2008.

You can read more about this utility and download it from here.