SAP ABAP Data Element MSQEXTFRAG (Extent fragmentation in scanning the leaf pages of an index)
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 | MSQEXTFRAG |
| Short Description | Extent fragmentation in scanning the leaf pages of an index |
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 | 16 | |
| Decimal Places | 2 | |
| 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 | Ext frag |
| Medium | 11 | Extent frag |
| Long | 36 | Extent fragmentation |
| Heading | 49 | Extent fragmentation scanning leaf level of index |
Documentation
Definition
Percentage of out-of-order extents in scanning the leaf-pages of an index.
This number is not relevant to heaps. An out-of-order extent is one for which
the extent containing the current page for an index is not physically the next
extent after the extent containing the prevous page for an index.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 50A |
