SAP ABAP Data Element MSSPBCACHT (Percentage of pages found in the buffer cache)
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
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 | MSSPBCACHT |
| Short Description | Percentage of pages found in the buffer cache |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | DEC | Counter or amount field with comma and sign |
| Length | 13 | |
| Decimal Places | 3 | |
| Output Length | 17 | |
| 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 | CacheHit% |
| Medium | 20 | Data cache hit ratio |
| Long | 22 | Data cache hit ratio % |
| Heading | 22 | Data cache hit ratio % |
Documentation
Definition
Percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups since SQL Server was started. The buffer cache is also known as the data cache.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 630 |
