Monitoring SQL Interface Resources
Chapter contents
This section describes the following options for monitoring the Relational Database Engine:
Monitoring Active SQL Connection Manager Sessions
To view active SQL Connection Manager Sessions:
- Choose Active Connections from the SQL menu on Monitor's main screen.
- The SQL Connection Manager Active Sessions window appears, as shown below.
Figure 11-8 SQL Connection Manager Active Sessions Dialog Box
Understanding Session Information
The SQL Connection Manager Active Sessions dialog box contains information about connected users, data sources, and applications in use.
The top Active Sessions label displays the number of active SQL Connection Manager sessions. The User Name list box displays the list of connected user names. User Name is set by default to the Windows login ID. If this is unavailable, User Name is set to "unknown".
More information about the selected User Name is displayed in the Session Information group box. By default, it displays the following information about the user:
|
Client Host Name
|
This is the client's machine or host name of the selected User Name. If unavailable, this is set to "Unknown."
|
|
Network Address
|
This is the client's IP or SPX address for the selected User Name. If unavailable, this is set to "Unknown."
|
|
Client Application
|
This is the connected application or module. If unavailable, this is set to "Unknown."
|
|
Data Source Name
|
This is the name of the engine DSN referenced by the client application.
|
|
Connection Status
|
This is the connection status for the selected User Name. A possible status may be "Active", "Idle", "Dying", or "Unknown" if status is unavailable.
|
|
Active/Idle Period
|
This refers to the duration of time, in milliseconds, since the connection has been active or idle.
|
|
Total Connection Time
|
This refers to the duration of time, in seconds, since the connection has been established.
|
Refreshing the Active Session List
- Click Refresh Session List or enable the Automatic Refresh checkbox.
- To change the Automatic Refresh rate, choose Settings from the Options menu on Monitor's main dialog box. The Monitor Settings dialog box appears, as shown below. The default refresh rate is 4 seconds.
Figure 11-9 Monitor Settings Dialog Box
Deleting an Active Session
- Select the session to be deleted by clicking on the desired user name in the User Name list box.
- Click Delete Session and the SQL Connection Manager deletes the selected session.
Note
If a large SQL statement is being processed by an active session when you terminate it, the session may be temporarily listed as "Dying." The session should disappear from the display when the engine reaches an appropriate termination point.
