SAP ABAP Data Element MSSCACHEHITRATIO (Procedure cache hit ratio)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Data Element	MSSCACHEHITRATIO
Short Description	Procedure cache hit ratio

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	MSSCOLLSLOPE
Data Type	DEC	Counter or amount field with comma and sign
Length	16
Decimal Places	3
Output Length	21
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Hit ratio
Medium	15	Cache hit ratio
Long	25	Procedure cache hit ratio
Heading	25	Procedure cache hit ratio

Documentation

Definition

Current Cache hit ratio. Ratio between all cache requests and the cache requests which could be handled without reading data from disk.

Do not mix up this cache hit ratio with the "data buffer" hit ratio. Cache objects include objects like parsed stored procedures, SQL plans, ad hoc TSQL statements, prepared TSQL statements and triggers (=SQL activity).

This counter is derrived from virtual system table master..sysperfinfo (Cache hit ratio/base). The counter does not reflect the hit ratio since startup because SQL Server provides this counter as a counter which is updated and reset on a regular base.

Use

Dependencies

Example

History

Last changed by/on	SAP	20110908
SAP Release Created in	640