FIX: Access violation exception occurs when promoting latches of frequently used database pages in SQL Server 2017

Se aplica a: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Assume that you run Microsoft SQL Server 2017 in a virtualization environment, such as VMWare, in which hot-add CPU and memory functionality are enabled. In this situation, you may notice that the SQL Server process may terminate unexpectedly and generate an access violation exception in the error log. 

Cause


The exception occurs when SQL Server attempts to promote the latch to super latch for database pages that are frequently used.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


This issue is fixed in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: 

More Information


For more information on the best practices to be followed for SQL Server configurations on virtualization environment, see Best practices for SQL Server configurations on VMware.

References


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