Monitoring SQL Interface Resources

---

This section describes the following options for monitoring the Relational Database Engine:

• Monitoring Active SQL Connection Manager Sessions
• Understanding Session Information
• Refreshing the Active Session List
• Deleting an Active Session

Monitoring Active SQL Connection Manager Sessions

To view active SQL Connection Manager Sessions:

1. Choose Active Connections from the SQL menu on Monitor's main screen.
2. 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

1. Click Refresh Session List or enable the Automatic Refresh checkbox.
2. 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

1. Select the session to be deleted by clicking on the desired user name in the User Name list box.
2. 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.

---