FIX: MEMORYCLERK_SOSMEMMANAGER grows larger and FAIL_PAGE_ALLOCATION error is logged after you enable large page allocations

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

Symptoms


Assume that in an instance of Microsoft SQL Server 2017, you enable large page allocations by using trace flag 834. In this situation, you may find that MEMORYCLERK_SOSMEMMANAGER clerk keeps growing larger and larger. Eventually, SQL Server may log the following error message in the SQL Server error log:

Note This issue does not occur if you disable trace flag 834.

Resolution


This fix is included in the following update for SQL Server:

Cumulative Update 10 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 standard terminology Microsoft uses to describe software updates.