SAP ABAP Data Element MSQCFFIBER (Controls whether SQL Server runs in fiber or thread mode)
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 | MSQCFFIBER |
| Short Description | Controls whether SQL Server runs in fiber or thread mode |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | CHAR1 | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| 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 | fiber |
| Medium | 0 | |
| Long | 0 | |
| Heading | 0 |
Documentation
Definition
This advanced option is used to allow SQL Server to use fiber schedulinginstead of thread scheduling. Using fiber mode can reduce context switching. The SAP set default is to use thread mode, which has provided better performance in most cases.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
