Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 10749795
KB4043455 - FIX: Portability and performance differ between Windows and Linux scheduler mappings in SQL Server 2017 - Microsoft Support
Last update date:
7/20/2023
Affected products:
SQL Server 2017 on Linux (all editions)
Affected releases:
build lower than 14.0.3006.16
Fixed releases:
14.0.3006.16
Description:
Symptoms
When you use schedulers in instances of SQL Server 2017 to map to individual processors, portability and performance differ between a Windows-based system and a Linux-based system.
Cause
This problem may occur because SQL Server scheduler mappings to a physical core or logical-processor can differ between Windows and Linux implementations for the same underlying system if hyper-threading (HT) is turned on. This condition affects portability and performance. In Windows, the two adjacent schedulers (even/odd) map to adjacent logical processors on the same core. In Linux, the schedulers may map to logical processors on two adjacent cores. This may unintentionally affect performance and the decision-making process for thread assignment to schedulers.
Resolution
This fix is included in Cumulative Update 1 for SQL Server 2017.
About SQL Server 2017 builds
Each new build for SQL Server 2017 contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for SQL Server 2017.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology that Microsoft uses to describe software updates.
