Viewing Cache Statistics

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

In the Perspective Resources view, select the resource, and select Resource > 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 buffer 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 buffer, and temporary caches appear.
Cache Statistics	Displays the cache statistics for the catalog, main buffer, 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 buffer, 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 buffer, and temporary cache pages. Pinned (%) – percentage of the catalog, main buffer, 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 buffer 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 buffer, and temporary caches appear.

Cache Statistics

Displays the cache statistics for the catalog, main buffer, 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 buffer, 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 buffer, and temporary cache pages.
Pinned (%) – percentage of the catalog, main buffer, and temporary chaches pinned.