Browse Sessions

Use the Session Browser to view and work with sessions. From the Session Browser, you can perform the following actions:

View detailed information, including program name, status, executed command, physical IO, and memory usage for any connection
Trace processes
Kill processes
Send a SQL statement to the Editor (Last T-SQL command batch tab at the bottom of the window)
View locks being held by sessions (Locks tab at the bottom of the window)
View distribution charts on the process activity (Charts tab at the bottom of the window). Select one or more processes and metrics to build the charts.

To monitor a session

Select Tools | Monitor | Session Browser.

Tips:

Right-click a process and select Kill Process to end the process.

Right-click a process and select Start Trace to start tracing the activity of the application.

Click and select the Enable threshold highlighting checkbox to enable CPU threshold monitoring.