Spotlight on SAP ASE 2.12 - User Guide

The Memory panel displays information about the following:

• Memory allocated to the ASE

• Data cache size

• Data cache hit rate

• Procedure cache size

• Procedure cache hit rate

• Metadata cache Open DBs

• Metadata cache Open Objects

• Metadata cache Open Index

This section of the Home Page displays data for the number of data cache physical writes and data cache physical reads per second.

This section of the Home Page displays the rate at which stored procedures are read from disk.

As users execute stored procedures, Adaptive Server looks in the procedure cache for a query plan to use. If a query plan is available, execution begins.

If no plan is in memory, or if all copies are in use, the query tree for the procedure is read from disk.

The Disk Storage panel has two main sections:

• I/O Busy

• Databases

I/O Busy

In addition to showing ASE performance of I/O related tasks (as a percentage), the I/O Busy section also displays the number of I/O disk devices.

Databases

In addition to displaying the number of databases, the Databases section shows:

• Size of the fullest database being monitored

• Percentage of space used by the fullest database, along with a container representing this same data

• Size of the fullest transaction log being monitored

• Percentage of space used by the fullest transaction log, along with a container representing this same data

• Size of the fullest Temp DB being monitored

• Percentage of space used by the fullest temp DB, along with a container representing this same data