升级后验证计划指南Validate Plan Guides After Upgrade

适用于: 是SQL Server是Azure SQL 数据库否Azure SQL 数据仓库否并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

建议在将应用程序升级到 SQL ServerSQL Server的新版本时,重新评估和测试计划指南定义。We recommend re-evaluating and testing plan guide definitions when you upgrade your application to a new release of SQL ServerSQL Server. 性能优化要求和计划指南匹配行为可能会发生更改。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. 将数据库升级到 SQL Server 2017SQL Server 2017后,建议执行下列任务:After upgrading a database to SQL Server 2017SQL Server 2017, we recommend that you perform the following tasks: