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.
