Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. We can capture and save data about each event to a file or table to analyze later. For example, we can monitor a SQL Server database to see which stored procedures are affecting performance by executing too slowly. SQL Server Profiler is used for activities such as: 

• Stepping through problem queries to find the cause of the problem.

• Finding and diagnosing slow-running queries.

• Capturing the series of Transact-SQL statements that lead to a problem. The saved trace can then be used to replicate the problem on a test server where the problem can be diagnosed.

• Monitoring the performance of SQL Server to tune workloads using Database Engine Tuning Advisor.