Wednesday, August 11, 2010

Capture an Analysis Services trace and log it into a SQL Server table

http://www.codeplex.com/wikipage?ProjectName=MSFTASProdSamples&title=SS2008!Readme%20for%20ASTrace%20Utility%20Sample&referringTitle=Home

This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.
The ASTrace utility gives you the ability to capture an Analysis Services trace and log it into a SQL Server table. The table can then be queried 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 by using a standard trace template that you can author using SQL Server Profiler.

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.