SQL Server - Session Manager

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available Operations for Sessions tab
Refresh : Refreshes all the tab results from the database
Reconnect : Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box
Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"
Expand all : Expands all user's sessions available
Collapse all: Collapses all user's sessions available
Kill Session: Allows to kill selected session
Last SQL: Shows a SQL extraction for the session selected
Group Sessions: Allows to group running sessions by User Name, Database, Status, Command, Application, Hostname, and Network Library, allowing to locate sessions easier
Toggle status color coding: Shows colors to differentiate the status of the sessions

Available Operations for Session Stats tab
Refresh : Refreshes all the tab results from the database
Reconnect : Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box
Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"

Available Operations for Locks tab
Refresh : Refreshes all the tab results from the database
Reconnect : Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box
Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"

Sessions Tab - Provides a list of sessions currently held by the MS SQL server, as a tree view

User: Server user name (login)
Process ID: Process ID
Context ID: Execution context ID used to uniquely identify the sub threads operating on behalf of a single process
Database: Database name
Status: Process status
Open Transactions: Number of open transactions for the process
Command: Command or process currently being executed
Application: Name of front-end module
Wait Time: Current wait time in milliseconds. 0 = Process is not waiting.
Wait Type: Reserved
Wait Resource: Textual representation of a lock resource
CPU: Cumulative CPU time for process in ticks
Physical IO: Number of disk reads and writes for current command
Memory Usage: Amount of memory allocated to process
Login Time: Time at which a client process logged into the server. For system processes, the time at which the SQL Server startup occurred is stored.
Last Batch: Last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the time at which the SQL Server startup occurred is stored.
Host: Name of host computer
Network Library: Column in which the client’s network library is stored. Every client process comes in on a network connection. Network connections have a network library associated with them that enables them to make the connection.
Network Address: Assigned unique identifier for the network adapter on the workstation of each user. When a user logs in, this identifier is inserted in the net_address column.
Blocked By: Process ID of blocking process, if any
Blocking: Whether the process is blocking another process

Sessions Stats Tab - Provides a list of sessions currently held by the MS SQL server

Process ID: Process ID
Context ID: Execution context ID used to uniquely identify the sub threads operating on behalf of a single process
User: Server user name (login)
Database: Database name
Status: Process status
Open Transactions: Number of open transactions for the process
Command: Command or process currently being executed
Application: Name of front-end module
Wait Time: Current wait time in milliseconds. 0 = Process is not waiting.
Wait Type: Reserved
Wait Resource: Textual representation of a lock resource
CPU: Cumulative CPU time for process in ticks
Physical IO: Number of disk reads and writes for current command
Memory Usage: Amount of memory allocated to process
Login Time: Time at which a client process logged into the server. For system processes, the time at which the SQL Server startup occurred is stored.
Last Batch: Last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the time at which the SQL Server startup occurred is stored.
Host: Name of host computer
Network Library: Column in which the client’s network library is stored. Every client process comes in on a network connection. Network connections have a network library associated with them that enables them to make the connection.
Network Address: Assigned unique identifier for the network adapter on the workstation of each user. When a user logs in, this identifier is inserted in the net_address column.
Blocked By: Process ID of blocking process, if any
Blocking: Whether the process is blocking another process

Locks Tab - Provides a list of Transaction, DML and PL/SQL locks currently held by the server, as a tree view

Session/Lock: Name of session or lock
Status: Process status
Type: Lock Type
Mode: Resource lock mode that the Database Engine uses
User: Server user name(login)
Session ID: Session ID
Database: Database name
Object: Object (table) name to be locked
Host Name: Name of host computer
Program: Name of front-end module
Blocking: Indicates if the session is blocking another one