Should the host machine always be restarted after upgrading an SQL Server 2008 instance?
There can be some memory usage downgrade, especially if Sql Server uses Large Page Extensions, otherwise - all the issues are minimal and negligible.