Viewing Multiplex Connection Statistics

Display the connection statistics for all servers in an SAP Sybase IQ multiplex.

In the Perspective Resources window, select the resource, click the arrow, and select Monitor Multiplex.
In the left pane of the IQ Multiplex Level Monitor view, select Connections.
To display a list of connections in the Multiplex Connections area, click the arrow beside the server name.
On the Active Connections tab, click the bar chart for a server to display the active connection details in a pie chart.

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 > Multiplex Connections	Displays all users currently connected to each server, including: Server – the name of the server. User ID – the ID of the connected user. 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. Name – the name of the connection. Connection create time – the date and time the connection was established. 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 > User Connections/Disconnections Per Minute	Displays the number of user connections and disconnections per minute for each server.
Active Connections tab	Displays a chart of the number of user, internode incoming, and other connections to the selected server.

Area

Description

Connections tab > Multiplex Connections

Displays all users currently connected to each server, including:

Server – the name of the server.

User ID – the ID of the connected user.

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.

Name – the name of the connection.

Connection create time – the date and time the connection was established.

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 > User Connections/Disconnections Per Minute

Displays the number of user connections and disconnections per minute for each server.

Active Connections tab

Displays a chart of the number of user, internode incoming, and other connections to the selected server.