Upgrading SQL Server and Caching Execution Plans

Question

I just upgraded SQL Server 2008 R2 Express Edition to the standard version of SQL Server 2008 R2. The configuration tool performed the update without any problems.

However, the promised performance improvement is not here. For example, SQL Server uses a single processor core.

I assume that SQL Server still uses the "old" execution plans for SP. If so, is there a way to rebuild / reset execution plans?

Or should I consider something else when upgrading from Express to Standard?

Please also let me know if this should be moved to ServerFault.

Answer 1

. , . "" , , , - R2.

, SQL Server , :

• /, concurrency
• , ( , , ).
• ( )
• , SQL Server .