What is SQL Profiler?

 

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.

·         Stress analysis.

·         General debugging and troubleshooting.

·         Fine-tuning indexes.

·         Auditing and reviewing security activity