Improvement: Improves the performance of SQL Server 2017 on smaller systems

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Summary


This update improves the performance of SQL Server 2017 when it is running on smaller systems that have less memory.

Resolution


This improvement is included in the following cumulative update for SQL Server:

       Cumulative update 4 for SQL Server 2017

More Information


SQL Server adjusts when it is running on smaller systems. For example, the default max worker calculation reduces the target level, and SQL common language runtime (CLR) hosting enables client mode garbage collection instead of server mode garbage collection.

References


Learn about the terminology that Microsoft uses to describe software updates.