Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a new table in SQL Server and loads your trace file into it: SELECT * INTO MyTraceTemp FROM :: fn_trace_gettable ( 'c:\x\MyTrace.trc' , default ) The default parameter means that if the trace is across
Read More...
Read the complete post at http://blogs.msdn.com/nav_developer/archive/2009/07/07/read-a-trace-file-into-a-sql-table.aspx
Posted
Jul 7, 2009 9:03
by
Nav developer's blog