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.
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)
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.