Procedure Cache Statistics

The metrics in this category provide statistics relating to Adaptive Server procedure cache.

Collection frequency - Every 30 minutes

Table 4-35 Procedure Cache Statistics Metrics

Metric	Description
Procedure Cache Hit Ratio (%)	Procedure cache hit ratio percentage. The upload frequency is after every sample and the operator is >. Alert text is - Procedure Cache hit ratio is %HitRatio%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
For Release 6 Number of stored procedures loaded into cache For Release 7 Stored procedures load rate into procedure cache (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of stored procedures loaded into the cache since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the stored procedures were loaded into the cache since last collection, that is, the number of stored procedures loaded into the cache since last collection divided by the elapsed time between two collections.
Miss Ratio (%)	Procedure Cache Miss Ratio.
For Release 6 Number of stored procedures requested For Release 7 Stored procedures request rate from procedure cache (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of stored procedures requested since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the stored procedures where requested since last collection, that is, the number of stored procedures required since last collection divided by the elapsed time between two collections.
For Release 6 Number of stalls for a free procedure cache buffer For Release 7 Procedure cache stalls rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of times a process had to wait for a free procedure cache buffer when installing a stored procedure into the cache. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which a process had to wait for a free procedure cache buffer since last collection, that is, the number of times a process had to wait for a free procedure cache buffer divided by the elapsed time between two collections.
For Release 6 Number of times a procedure normalized For Release 7 Procedures normalize and write back rate to sysproced's(per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of times a procedure was normalized and the tree written back to sysprocedures since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which a procedure was normalized since last collection, that is, the number of times a procedure was normalized and the tree written back to sysprocedures since last collection divided by the elapsed time between two collections.
For Release 11 Procedure Cache Used Memory(MB)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 11 (1.3.1.0.0) Memory used in the procedure cache

Metric

Description

Procedure Cache Hit Ratio (%)

Procedure cache hit ratio percentage. The upload frequency is after every sample and the operator is >. Alert text is - Procedure Cache hit ratio is %HitRatio%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.

For Release 6

Number of stored procedures loaded into cache

For Release 7

Stored procedures load rate into procedure cache (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of stored procedures loaded into the cache since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the stored procedures were loaded into the cache since last collection, that is, the number of stored procedures loaded into the cache since last collection divided by the elapsed time between two collections.

Miss Ratio (%)

Procedure Cache Miss Ratio.

For Release 6

Number of stored procedures requested

For Release 7

Stored procedures request rate from procedure cache (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of stored procedures requested since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the stored procedures where requested since last collection, that is, the number of stored procedures required since last collection divided by the elapsed time between two collections.

For Release 6

Number of stalls for a free procedure cache buffer

For Release 7

Procedure cache stalls rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of times a process had to wait for a free procedure cache buffer when installing a stored procedure into the cache.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which a process had to wait for a free procedure cache buffer since last collection, that is, the number of times a process had to wait for a free procedure cache buffer divided by the elapsed time between two collections.

For Release 6

Number of times a procedure normalized

For Release 7

Procedures normalize and write back rate to sysproced's(per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of times a procedure was normalized and the tree written back to sysprocedures since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which a procedure was normalized since last collection, that is, the number of times a procedure was normalized and the tree written back to sysprocedures since last collection divided by the elapsed time between two collections.

For Release 11

Procedure Cache Used Memory(MB)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 11 (1.3.1.0.0)

Memory used in the procedure cache