-SQL Server provides a graphical tool which helps system administrators to monitor T-SQL statements of Database Engine.

-SQL Profiler can capture and store data related to every event to a file or a table.

-SQL Server Profiler can be used

1. To create a trace

2. To store the trace results in a table.

3. To watch the trace results when the trace runs

4. To replay the trace results

5. To start, stop, pause, and modify the trace results