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

01_Steps to create the Profiler Trace

Steps to create the Profiler Trace

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

02_Steps to create the Profiler Trace

Steps to create the Profiler 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.

03_Steps to create the Profiler Trace

Steps to create the Profiler Trace

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”

04_Steps to create the Profiler Trace

Steps to create the Profiler Trace

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

05_Steps to create the Profiler Trace

Steps to create the Profiler Trace

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

06_Steps to create the Profiler Trace

Steps to create the Profiler Trace

 

07_Steps to create the Profiler Trace

Steps to create the Profiler Trace

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.