SAP ABAP Data Element MSSBUFHITRATIO (Datacache 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 MSSBUFHITRATIO
Short Description Datacache 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 30 Cache hit ratio 
Heading 35 Datacache hit ratio 
Documentation

Definition

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

This counter is derrived from virtual system table master..sysperfinfo (Buffer 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