Viewing Engine Statistics

Display the engine 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 Engine.
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.

Area Description
Engine Statistics Displays the statistics for the engine. The calculations are continuously updated based on live server information. The engine statistics include:
  • CPU total usage – percentage of CPU total usage.
  • CPU system usage – percentage of CPU system usage.
  • CPU user usage – percentage of CPU user usage.
  • Total memory allocated (MB) – total amount of memory (in megabytes) allocated for the main buffer cache, temporary buffer cache, and remaining heap.
  • Max memory allocated (MB) – maximum amount of memory (in megabytes) allocated for the main buffer cache, temporary buffer cache, and remaining heap.
  • Main cache (MB) – total size of the main buffer cache, in megabytes.
  • Temp cache (MB) – total size of the temporary buffer cache, in megabytes.
  • IQ threads in use – number of IQ threads in use.
  • IQ threads available – number of available IQ threads.
IQ Memory Shows the allocation of the IQ memory between the main buffer cache, temporary buffer cache, and remaining heap.
CPU History Displays the percentage of total, system, and user CPU usage over a period of time.
Parent topic: Monitor Simplex Servers
Related tasks
Viewing Overview Statistics
Viewing All Statistics
Viewing Connection 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