Viewing Cache Statistics

Display the cache statistics for the selected SAP 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 Caches.
Select the tab for the required information.

Note: Hover the mouse pointer over any line or bar graph to display information for that graph.

Tab	Description
Cache size	Catalog cache – the megabyte allocation for the catalog cache, and the number of megabytes in use. Main cache – the megabyte allocation for the main cache, and the number of megabytes in use. Temporary cache – the megabyte allocation for the temporary cache, and the number of megabytes in use.
Cache reads	Number of cache reads per second for a period of time. The cache reads for the catalog, main, and temporary caches appear.
Cache statistics	Displays the cache statistics for the catalog, main, and temporary caches. Each cache type includes statistics for: Size (mb) – total size of the cache, in megabytes. In use (%) – percentage of the cache being used. Reads (per second) – number of cache reads per second. Hits (per second) – number of hits, per second, to the the catalog, main, and temporary caches. Dirty pages (%) – percentage of pages in the catalog, main, and temporary caches where data has been modified and stored in the buffer cache and has not yet been written to disk. Pinned – number of pinned catalog, main, and temporary cache pages. Pinned (%) – percentage of the catalog, main, and temporary chaches pinned.

Tab

Description

Cache size

Catalog cache – the megabyte allocation for the catalog cache, and the number of megabytes in use.

Main cache – the megabyte allocation for the main cache, and the number of megabytes in use.

Temporary cache – the megabyte allocation for the temporary cache, and the number of megabytes in use.

Cache reads

Number of cache reads per second for a period of time. The cache reads for the catalog, main, and temporary caches appear.

Cache statistics

Displays the cache statistics for the catalog, main, and temporary caches. Each cache type includes statistics for:

Size (mb) – total size of the cache, in megabytes.

In use (%) – percentage of the cache being used.

Reads (per second) – number of cache reads per second.

Hits (per second) – number of hits, per second, to the the catalog, main, and temporary caches.

Dirty pages (%) – percentage of pages in the catalog, main, and temporary caches where data has been modified and stored in the buffer cache and has not yet been written to disk.

Pinned – number of pinned catalog, main, and temporary cache pages.

Pinned (%) – percentage of the catalog, main, and temporary chaches pinned.