SQL Profiler

SQL Server Profiler can be used to monitor activity from client applications to SQL Server. When working with SQL Server Profiler, it is helpful to understand SQL Trace. For more information, see SQL Trace. Neither should run without a watchful eye, as they can impact on performance.

• Open up Profiler
• Connect to the server
• In Trace Properties window click Run
• In Events Selection select the events to Trace. Double-click DatabaseName and select LIKE to define which db to trace
• Switch back to SSMS and run a query
• Switch back to Profiler and click Stop Trace
• In the Results grid, click individual statements to see the details shown in the lower pane