FIX: Access violation occurs when Query Store collects runtime statistics in SQL Server 2017

S'aplica a: SQL Server 2017 on WindowsSQL Server 2017 DeveloperSQL Server 2017 Enterprise

Symptoms


Assume that you use Query Store in SQL Server 2017 on a server that has more than 256 logical cores. When the Query Store is collecting runtime statistics, an access violation may occur. Eventually, SQL Server may fall into a non-yielding scheduler scenario and freeze.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 5 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.