Using 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.

Menu Path: Start | All Programs | Microsoft SQL Server | Performance Tools | SQL Server Profiler. 

1. Then following screen will come

  

 2.  Then in Event Selection Tab click on Show all events and Show all column's check box Check below image 

     3. Mark TSql check boxes as below check boxes. Tsql helps to display query. Full form is Trasect Sql.

   4. For Transaction display mark below check boxes .

 

   5. For Store procedure display Mark below check boxes.

  6.  Audit related things generally not required. So uncheck everything in audit as below.

 

  7.  Session related info also not required so un-check everything in session section as well.

   8.  So once all the settings are done , just click on Run button. Start yours application you will find below screen & Sql tracing starts.