Viewing Connection Statistics

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

  1. In the Perspective Resources view, select the resource, and select Resource > Monitor Node.
  2. In the left pane of the IQ Node Level Monitor view, select Connections.
  3. Select the tab for the required information.
Note:

  • Click a column header to sort the data by that column.

  • 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.

Tab Description
Connections  
  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
  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.
  Associated Transactions Displays the transaction ID, creation time, and state of transactions executed by the selected user.
Connection Statistics  
  Active Connections Displays a chart of the number of user, internode incoming, and other connections to the server.
  User Connections/Disconnections Per Minute Displays the number of user connections and disconnections per minute.
Parent topic: Monitor Simplex Servers
Related tasks
Viewing Overview Statistics
Viewing All Statistics
Viewing Engine Statistics
Viewing Transaction Statistics
Viewing Dbspaces Statistics
Viewing Store I/O Statistics
Viewing Cache Statistics
Viewing Table Version Statistics
Viewing Operations and Requests Statistics
Viewing Network Statistics
Viewing Table Page Usage Statistics
Viewing Table Lock Statistics
Viewing Deadlock Statistics
Viewing RLV Memory Usage Statistics
Viewing RLV Merge History Statistics
Viewing Monitor Settings Details
Viewing Multiplex Connection Statistics