SQl Profiler is a tool provided by SQL Server, which can 
capture the queries, procedures executed on the database. 
It also capture all the details like user, m/c, input 
parameters, time of execution etc. This is very helpful 
while bebugging any query / procedure.

SQL profiler is a graphical tool that allows system 
administrator to monitor in an instance of the SQL Server.

Use of SQL Profiler:
•	Monitor the performance of an instance of SQL 
Server.
•	Debug Transact-SQL statements and stored procedures.
•	Identify slow-executing queries.
•	Test SQL statements and stored procedures in the 
development phase of a project by single-stepping through 
statements to confirm that the code works as expected.
•	Troubleshoot problems in SQL Server by capturing 
events on a production system and replaying them on a test 
system. This is useful for testing or debugging purposes 
and allows users to continue using the production system 
without interference.
•	Audit and review activity that occurred on an 
instance of SQL Server. This allows a security 
administrator to review any of the auditing events 
including the success and failure of a login attempt and 
the success and failure of permissions in accessing 
statements and objects.