| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
Validate Plan Guides After Upgrade |
When you upgrade your application to a new release of SQL Server, we recommend that you re-evaluate and test plan guide definitions. |
MikeRayMSFT |
mikeray |
03/14/2017 |
sql |
performance |
conceptual |
|
[!INCLUDE SQL Server Azure SQL Database]
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.