FIX: Access violation when you query by using “sys.dm_db_tuning_recommendations” in SQL Server

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

Symptoms


You query by using sys.dm_db_tuning_recommendations dynamic management view (DMV) in SQL Server 2017. If SQL Server query optimizer (QO) uses a parallel query execution plan, an access violation may occur, and a dump file is generated.

Resolution


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

Cumulative Update 13 for SQL Server 2017

Workaround


To work around this issue, use the following option when you query sys.dm_db_tuning_recommendations to remove parallelism and avoid the risk of an access violation:

OPTION (MAXDOP 1)

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.