SQL Server Profiler

SQL Server Profiler is a tool that captures Microsoft® SQL Server™ events from a server. The 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. 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 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.

SQL Server Profiler

See Also