SQL Profiler is a tool that captures SQL Server events from the server and saves those events in what's known as a trace file. You can then analyze or use the trace file to troubleshoot logic or performance problems.
You can use this utility to monitor several areas of server activity, such as:
Analyzing and debugging SQL statements and stored procedures.
Monitoring slow performance.
General debugging and troubleshooting.
Auditing and reviewing security activity.
To access Profiler, you must be the administrator or have permission to connect to a specific instance of SQL Server and have granted permissions to execute Profiler stored procedures.