Sybase DBA Tools - Session Manager
Provides manageability for database sessions including user locks that allows a user to monitor and kill sessions.
|
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
Sybase server, as a tree view
User: Server user name (login)
Process ID: Process ID
FID: Process ID of the worker process' parent
Kernel Process ID: Kernel process ID
Engine Num: Number of engine on which process is being executed
Status: Process status
SUID: Server user ID of user who issued command
Host Name: Name of host computer
Program Name: Name of front-end module
Host Process: Host process ID number
Command: Command or process currently being executed
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
Blocked: Process ID of blocking process, if any
Database: Database name
Client Name: Name by which the user is known for the current session
Client Host Name: Name by which the host is known for the current session
Client App Name: Name by which the application is known for the current session
Client IP: IP address of the client where the login is made
|
Sybase DBA Tools - Session Manager - Syntax Coloring
Sybase DBA Tools - Session Manager - Sessions Tab |
Sessions Tab - Session Detail - This tab provides detailed information on the
currently selected session
|
Sybase DBA Tools - Session Manager - Session Details Tab |
Sessions Stats Tab - Provides a list of sessions currently held by the
Sybase server
Process ID: Process ID
FID: Process ID of the worker process' parent
Kernel Process ID: Kernel process ID
Engine Num: Number of engine on which process is being executed
Status: Process status
SUID: Server user ID of user who issued command
User: Server user name (login)
Host Name: Name of host computer
Program Name: Name of front-end module
Host Process: Host process ID number
Command: Command or process currently being executed
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
Blocked: Process ID of blocking process, if any
Database: Database name
Client Name: Name by which the user is known for the current session
Client Host Name: Name by which the host is known for the current session
Client App Name: Name by which the application is known for the current session
Client IP: IP address of the client where the login is made
|
Sybase DBA Tools - Session Manager - Session Statistics Tab |
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
Session ID: Session ID
Status: Process status
Blocking: Indicates if the session is blocking another one
Type: Lock Type
User: Server user name(login)
Database: Database name
Object: Object (table) name to be locked
FID: Process ID of the worker process' parent
Host: IP address of the client host
Program: Name of front-end module
Client Name: Name by which the user is known for the current session
Client Host Name: Name by which the host is known for the current session
Client App Name: Name by which the application is known for the current session
Client IP: IP address of the client where the login is made
|
Sybase DBA Tools - Session Manager - Locks Tab |
