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.
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. |
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 |
|