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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.