| title | Validate Plan Guides After Upgrade | |
|---|---|---|
| description | When you upgrade your application to a new release of SQL Server, we recommend that you re-evaluate and test plan guide definitions. | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| ms.date | 03/14/2017 | |
| ms.service | sql | |
| ms.subservice | performance | |
| ms.topic | how-to | |
| ms.custom |
|
|
| helpviewer_keywords |
|
|
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]
Important
Query Store hints provide an easier-to-use method for shaping query plans without changing application code. Query Store hints are simpler than plan guides. Query Store hints are available in [!INCLUDE ssazure-sqldb], [!INCLUDE fabric-sqldb], [!INCLUDEssazuremi-md], and in [!INCLUDEsssql22-md] and later versions.
We recommend re-evaluating and testing plan guide definitions when you upgrade your application to a new release of [!INCLUDEssNoVersion]. Performance tuning requirements and plan guide matching behavior may change. Although an invalid plan guide will not cause a query to fail, the plan is compiled without using the plan guide and may not be the best choice. After upgrading a database to a newer version of the [!INCLUDE ssde-md], we recommend that you perform the following tasks:
-
Validate existing plan guides by using the sys.fn_validate_plan_guide function.
-
Use extended events to monitor for misguided plans for some period of time by using the Plan Guide Unsuccessful event.