Viewing Engine Statistics

Display the engine statistics for the selected Sybase IQ server.

In the Perspective Resources window, select the resource, click the arrow, and select Monitor Node.
In the left pane of the IQ Node Level Monitor view, select Engine.

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
Engine statistics table	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 cache, temporary cache, and remaining heap. Max memory allocated (MB) – Maximum amount of memory (in megabytes) allocated for the main cache, temporary cache, and remaining heap. Main cache (MB) – Total size of the main cache, in megabytes. Temp cache (MB) – Total size of the temporary cache, in megabytes. IQ threads in use – Number of IQ threads in use. IQ threads available – Number of available IQ threads.
IQ memory chart	Shows the allocation of the IQ memory between the main cache, temporary cache, and remaining heap.
CPU history chart	Displays the percentage of total, system, and user CPU usage over a period of time.

Area

Description

Engine statistics table

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 cache, temporary cache, and remaining heap.

Max memory allocated (MB) – Maximum amount of memory (in megabytes) allocated for the main cache, temporary cache, and remaining heap.

Main cache (MB) – Total size of the main cache, in megabytes.

Temp cache (MB) – Total size of the temporary cache, in megabytes.

IQ threads in use – Number of IQ threads in use.

IQ threads available – Number of available IQ threads.

IQ memory chart

Shows the allocation of the IQ memory between the main cache, temporary cache, and remaining heap.

CPU history chart

Displays the percentage of total, system, and user CPU usage over a period of time.