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 Archives: 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.