Using the Connection Monitor

Prerequisites

You are in the Start of the navigation pathTroubleshooting Next navigation step Database Next navigation step Open SQL Monitors Next navigation step Connection MonitorEnd of the navigation path function of SAP NetWeaver Administrator.

Context

The Connection Monitor provides information about the connections obtained using Open and Native SQL DataSource objects.

Procedure

  1. The Accessed DataSources screen gives you an overview of all data sources that are currently accessed on each cluster node of the Java server. For each cluster node, information about the DataSource , Connections , and Connection Requests is displayed.

    • You can validate or destroy all connections to the selected DataSource by choosing Validate Connections or Destroy Connections , respectively. The latter provides the options to destroy all connections only when they are unused (after they are released by the relevant application) or immediately (cancels all statements that are currently being executed).

    • To switch the connection request trace for the selected DataSource on or off, choose Connection Request Trace .

    You can select a DataSource for which you want to monitor the established connections. The displayed list of DataSources contains those that have already been used to provide a connection.

  2. To view the available information about a particular connection, select the relevant DataSource in the Accessed DataSources area. The Open Connections tab in the Details about DataSource area displays the details of each connection. You can also choose the DataSource Properties or the Connection Request Statistics tabs to view additional information about the selected DataSource.

    • You can validate or destroy a particular connection by selecting the connection and choosing Validate or Destroy , respectively. The latter provides the options to destroy the connection only when it is unused (after it is released by the relevant application) or immediately (cancels the statement that is being executed currently).

    • You can remove all statements within the statement pool which is associated with a selected connection, by choosing Reset Statement Pool .

  3. To view information about statements for a particular connection, select the connection. The Open Statements tab in the Details About Connection area displays details of the SQL statement string, the type of the statement, and so on.

    To view information about the statement pool that is associated with the selected connection, choose the Statement Pool Statistics tab.