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.

Host

Refers to the IP address of the Sybase server.

Port

The port number at which the Sybase server listens to.

User

A Sybase user who has the “sa_role”.

Password

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

Trans/Sec

 

Disk reads

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

Reads/Sec

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

Cache hit ratio

Percentage of procedure requests served from cache

Percent

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/Sec

 

Procedures aged out of cache

The number of times that a procedure aged out of cache

Procedures/Sec