Flight Recorder in SSAS

Hi -

I am trying to use fight recorder in analysis services. But when I replay a trace file I shows only very few columns in output.

Is there any way to see all the coulums when you replay the trace?Any kind of setting that I need to modify.

Thanks,

Deepak,

The events and columns captured by the Flight Recorder are controlled by a trace definition file. The advanced server property named Log\FlightRecorder\TraceDefinitionFile controls the definition file used by the Fligth Recorder. By default, the property is blank, which means the Flight Recorder defaults to using the trace file definition stored in the file flightrecordertracedef.xml, which is stored in the ..\OLAP\bin directory wherever SSAS is installed.

Patrice Truong does a nice job of explaining how to modify the trace definition file in the following blog entry:

http://patrice-truong.spaces.live.com/blog/cns!62BC7696F42B5!181.entry

One thing I'd likely recommend is saving the modified flightrecordertracedef.xml file as a new name, then update the server property listed above to reflect that new file name (to keep the original file in tact just in case you need to revert to it for some reason).

HTH,

Dave Fackler

sql