Sql server profiler

SQL Server Profiler is a graphical interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.

Open the Sql server profiler

There are two way to open the sql server profiler

Ø  Sql server management studio

Ø  Performance tool

Opening sql server profiler from Sql server management studio

Open SSMS -> Tools

Click on Sql server profiler

A new window will be open

Connect the database server

And run the profiler.

Open sql server profiler using Performance tool

Go to Start

Start -> all programs -> Microsoft sql server 2012 -> Performance Tool -> sql server profiler

Click on the sql server profiler. A new window will be open

Click on below icon to connect to the server

Select the server and connect the server

Run the profiler

  

Once we run the profiler the monitoring window will be open.

 Here we will profile our query

Let’s the example.

I am running a sql script on SSMS

We can see this query in the profiler.