SAP ABAP Data Element MSSEXTSCANFRAG (Extent scan fragmentation)
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 MSSEXTSCANFRAG
Short Description Extent scan fragmentation  
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 5    
Decimal Places 2    
Output Length 6    
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 ExScanFrag 
Medium 15 Ext. scan frag. 
Long 20 Extent scan frag. 
Heading 30 Extent scan fragmentation 
Documentation

Definition

Percentage of out-of-order extents in scanning the leaf pages of an index. This value 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 previous page for an index.

Use

Dependencies

Example

History
Last changed by/on SAP  20110908 
SAP Release Created in 620