Viewing Connection Statistics

Display the connection statistics for the selected SAP Sybase IQ server.

In the Perspective Resources window, select the resource, click the arrow, and select Monitor Node.
In the left pane of the IQ Node Level Monitor view, select Connections.
Select the tab for the required information.

Note: To display the information in a chart or table in the full window, select the Maximize icon in the top right of the area.

Hover the mouse pointer over any line or bar graph to display information for that graph.

Area	Description
Connections tab > Active connections	Displays all users currently connected to the server, including: User ID – the ID of the connected user. Name – the name of the connected user. Creation time – the date and time the connection was established. Connection ID – the ID of the connection. State – the current state of the selected connection. Possible states include: ACTIVE – the connection is live. SUSPENDED – the connection and its corresponding transaction are suspended, probably due to hardware or communication failure. Client IP address – the IP address of the client that made the connection. Connection or cursor –indicates a connection or an active cursor
Connections tab > Connection details	Select a User ID to display that user's specific connection details, including: Statement being executed – the statement executed by the selected user. Last request time – the last time a request was executed on the server by the selected user. Request type – type of request executed by the selected user. Last command time – the last time a command was executed on the server by the selected user. Command type – type of command executed by the selected user. IQ temporary store usage (KB) – number of temporary store kilobytes used during the connection. IQ temporary work space usage (KB) – number of temporary workspace kilobytes used during the connection. Cursor count – number of open SAP Sybase IQ cursors on the connection. Thread in use – number of threads in use by the selected user.
Connections tab > Associated transactions	Displays the transaction ID, creation time, and state of transactions executed by the selected user.
Connection Statistics tab > Active connections	Displays a chart of the number of user, internode incoming, and other connections to the server.
Connection Statistics tab > User connections/disconnections per minute	Displays the number of user connections and disconnections per minute.