how to save profiler trace into sql server table.

SQL Tech

How can I save a SQL Server Profiler trace and read it using a T-SQL command?

Naren 0Comment

1.Save the Trace File:

  • Open SQL Server Profiler.Configure the trace by setting the events and filters as needed.Start the trace.Save the trace results to a file by selecting File > Save As > Trace File.Provide a file name xyz and save it.

2.Read the Trace File Using T-SQL:

  • Use the fn_trace_gettable function to read the trace file.

Here is an example T-SQL command to read the saved trace file: