|
|
|
Session Manager -
Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
|
Toolbar Operations -
Refresh : Refresh all the tab results from the database
Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled
Auto Refresh: Indicates whether to refresh the tab results automatically every X number
of seconds determined by the "Refresh Seconds"
Kill Session: Allows to kill selected session
Group Sessions: Allows to group running sessions by User Name, Program Name, Database, Status, Hostname, Command, allowing to locate settions easier
|
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 subthreads 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 Tab - Session Detail - This tab provides detailed information on the
currently selected session
|
 |
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 subthreads 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
Sybase server, as a tree view
Session/Lock: Name of session or lock
Status: Process status
Type: Lock Type
Mode:
User: Server user name(login)
Session ID: Session ID
Database: Database name
Object: Object (table) name to be locked
FID: Process ID of the worker process' parent
Host Name: Name of host computer
Program: Name of front-end module
Blocking: Indicates if the session is blocking another one
|
 |
|
