Display the connection statistics for the selected Sybase IQ server.
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. Client IP address – the IP address of the client that made the connection. |
|
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 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, internode outgoing, and other connections to the server. |
|
Connection Statistics tab > User connections/disconnections per minute |
Displays the number of user, internode incoming, internode outgoing, and other connections and disconnections per minute. |