how to use Sql Server Profiler

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring T-SQL Statements of Database Engine. We can save and reuse the state at a later point of time.

•We can do the following using SQL Server Profiler
    ◦Create a trace
    ◦Watch the trace results as the trace runs
    ◦Store the trace results in a table
    ◦Start, stop, pause, and modify the trace results as necessary
    ◦Replay the trace results
•Use SQL Server Profiler to monitor only the events in which you are interested

How To Start SQL Profiler
>In Sql Server 2000
    Start | Run | profiler | OK
>In Sql Server 2005
    Start | All Programs | Microsoft SQL Server 2005 | Performance Tools | SQL Server Profiler.