FIX: State of the ForceLastGoodPlan recommendation is falsely reported as Expired if applied manually in SQL Server 2017

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


If you apply the ForceLastGoodPlan recommendation in Microsoft SQL Server 2017, the state of the recommendation is falsely reported as "Expired" in the Dynamic Management View sys.dm_db_tuning_recommendations.

Resolution


This fix is included in Cumulative Update 2 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 Microsoft uses to describe software updates.