SQL 2005 (SQL 2008) Analysis Services Server Side Tracing

Written by Karan Gulati on 07 November 2009. Posted in Performance Tuning

With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as Server Side Tracing.

In this article we’ll talk about how to achieve Server Side Tracing.

How to create a Server Side Trace

Open SQL Server profiler connect to Analysis Services and in an Event Selection define the SSAS Events.