Sybase Proc Cache Test

This test reports the procedure cache statistics of a Sybase database server.

Target of the test : A Sybase ASE (Below v15) server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every Sybase ASE (Below v15) server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.


Refers to the IP address of the Sybase server.


The port number at which the Sybase server listens to.


A Sybase user who has the “sa_role”.


The password corresponding to the above user.

Confirm Password

Confirm the password by retyping it here.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Procedure requests

The number of times stored procedures were executed



Disk reads

The number of times that stored procedures were read from disk rather than found and copied in the procedure cache


If this value is consistently high, increase the procedure cache size.

Cache hit ratio

Percentage of procedure requests served from cache


If this value is low, consider increasing procedure cache memory or add more memory to the server.

Procedures created

The number of procedures created during the sample interval



Procedures aged out of cache

The number of times that a procedure aged out of cache