我刚刚将 SQL Server 2008 R2 Express 版升级到 SQL Server 2008 R2 标准版。安装工具已执行升级，没有任何问题。
然而，承诺的性能提升并不在这里。例如，SQL Server 使用单 CPU 核心。
我假设 SQL Server 仍然使用 SP 的“旧”执行计划。如果是这样，有没有办法重建/重置执行计划？
或者在将 Express 版本升级到 Standard 版本时我应该考虑其他事项吗？
另请告知我是否应将其移至 ServerFault。
I've just upgraded SQL Server 2008 R2 Express Edition to the SQL Server 2008 R2 Standard edition. The setup tool has performed the upgrade without any problems.
However, the promised performance boost is not here. For example, the SQL Server uses the single CPU core.
I assume that the SQL Server still uses the "old" execution plans for SPs. If so, is there a way to rebuild/reset execution plans?
Or should I consider something else when upgrading an Express to Standard edition?
Please also let me know if this should be moved to ServerFault.
发布评论
评论（1）
执行计划仅存在于内存中。升级产品意味着更换二进制文件，这意味着新的流程。因此，您不可能有“旧”计划，每个缓存或正在执行的计划都是新的 R2 计划。
至于为什么您没有看到 SQL Server 使用多核，可能有多种原因：
Execution plans are in memory only. Upgrading the product implies a replacement of the binaries, that implies a new process. Therefore you cannot possibly have a 'old' plans laying around, every single plan cached or in execution now is a new R2 plan.
As to why you do not see SQL Server using multiple cores, there could be a multitude of reasons: