Migration to 2008 R2. Not as easy as Copy & Paste [Performance]
Better hardware and the latest SQL Server release does not always mean that things will run faster.
Tag «sp_whoisactive»
Summarizing Performance issues and workarounds after migrating from 2005 to 2008 R2 [SQL Server]
We were able to tune the offending processes and go from 85% sustained CPU utilization to almost nil.