SQL Server – Steps to create the Profiler Trace

With the help of this post sharing with you the steps to create the Profiler Trace.

Open the SQL Server Management Studio >> Go to Tools >> SQL Server Profiler

It is mandatory for the user to have system admin rights to start the profiler. Once the profiler is started click on Menu >> File >> New Trace

Below screen display for Trace Properties

Here we are using the trace with default standard template for demo. You can choose as per requirement.

The Event selection screen contains a checkbox that can be configured as per the requirement of data to be collected.

Below screen contain the two buttons as “Column filters” and “Organize Columns”

Below screen display once we click on the Column filters button that can be used to filter the trace data

Below screen display once we click on the Organize Columns button that can be used to organize and group columns

 

The Trace Properties screen contains a Run button to start the trace. The trace can be paused or stopped as required.

Note:
Trace file (.trc) will be stored the selective location that you choose on Trace Properties screen. The trace can be stored in the table if required.