Using fn_trace_gettable to Import Trace Results

If you save a trace file to disk, how can you analyze it later? One way is to load it back into Profiler, but sometimes we wish for more powerful tools such as old fashioned SQL queries. We can use fn_trace_getdata function to load the data into a table and then work with it as we wish. Join Profiler Professor Jack Corbett for a quick look at how to use it.

I have been working with SQL Server since 1999 and have worked with versions 6.5 - 2005. I have experience in VB 6 and .NET (ASP.NET, VB.NET, C#). I currently work as a Software Developer for New Tribes Mission (www.ntm.org)

Robert Neal on 4/21/2009

Need more information. I have found trace to provide too much info.

Jack Corbett on 4/22/2009

Robert, What do you mean by too much info? Remember you can filter using a where clause on any of the columns included.

choudary on 5/26/2009

If possible please improve the quality of the video display

Tonci on 9/21/2009

Good to know. To use this function might become handy when less expected. Thank you.

Ranjith on 2/13/2010

Thanks. Great Video