Viewing Overview Statistics

Display high-level 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 Overview.
  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
Server
  • State – current status of the server. Valid states include:
    • Unknown
    • Stopped
    • Running
  • Host – host name where the server is running.
  • Port – port number where the server is running.
  • Server name – name of the server.
  • Database – name of the SAP Sybase IQ database.
  • Server type – type of server the database is on. Server types include Single Server, Coordinator, Reader, and Writer.
  • Server version – version of the SAP Sybase IQ server.
  • Platform – operating system running on the server host.
Activities
  • CPU total usage (%) – total CPU usage percentage, including both system and user usage.
  • Active connections – total number of active connections, including user and internode communication connections.
  • Connections available – number of connections available for users and internode communication connections.
  • Active requests – number of active requests on the server.
  • IQ threads in use – number of threads being used by the SAP Sybase IQ server.
  • Active transactions – number of active transactions.
  • Number of committed transactions – number of committed transactions.
  • Oldest transaction (minutes) – elapsed age, in minutes, of the oldest transaction.
Caches
  • Catalog cache reads (per second) – number of catalog cache page lookups per second.
  • Main cache size (MB) – size of the main buffer cache, in megabytes.
  • Temp cache size (MB) – size of the temporary cache, in megabytes.
  • Remaining heap size (MB) – size of the remaining heap allocation, in megabytes.
Version Usage
  • Number of committed versions – the number of table versions in the server.
  • Total version space used (MB) – total space consumed by all the table versions.
  • Oldest version ID – the oldest version identifier on the server.
  • Number of active versions – total number of active write table versions on the server.
  • Total active version space created (MB) – amount of data created by active write transactions.
  • Total active version space to be destroyed (MB) – amount of data destroyed by active write transactions. If these transactions commit, the destroyed data becomes an old version and is eventually dropped. If the transactions roll back, the created data is released.
Details
  • Server full version – version of the IQ server software, including the date and time.
  • Platform version – version of the operating system installed on the server host.
Alerts Any alerts for the selected server. While the monitor is open, alerts are displayed as they are created.
CPU History Percentage of total CPU usage over a period of time.
IQ Memory Allocation of the IQ memory between the main buffer cache, temporary cache, and remaining heap.
Disk Usage Available and used space for the main and temporary stores.
Parent topic: Quick Start for an Evaluation
Previous topic: Displaying Resource Availability: the Heat Chart
Next topic: Viewing Multiplex Overview Statistics