SAP ABAP Data Element MSSPCRATIO (Procedure cache hit ratio as percentage.)
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
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Data Element | MSSPCRATIO |
Short Description | Procedure cache hit ratio as percentage. |
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 | Hit ratio% |
Medium | 20 | Cache hit ratio % |
Long | 27 | Cache hit ratio in % |
Heading | 40 | Procedure cache hit ratio in % |
Documentation
Definition
Percentage of pages found in the cache without having to read from the disk. The ratio is the total number of cache hits divided by the total number of cache lookups since SQL Server was started.
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 630 |