SQL 2005 to SQL 2008 forklift upgrade resulted in 50% cpu utilisation (& resolution) – aka SBS 2003 to SBS 2008 SQL Application Movehttp://192.168.2.20/blogs/doverton/archive/2008/12/08/sql-2005-to-sql-2008-forklift-upgrade-resulted-in-50-cpu-utilisation-amp-resolution-aka-sbs-2003-to-sbs-2008-sql-application-move.aspxI’ve recently moved the database behind DavidOverton.com (also uksbsguy.com) from a Windows Server 2003 system with SQL 2005 to Windows Server 2008 with SQL 2008.&#160; This would be the same process if you were potentially performing a migration fromenCommunityServer 2008.5 SP2 (Build: 40407.4157)re: SQL 2005 to SQL 2008 forklift upgrade resulted in 50% cpu utilisation (& resolution) – aka SBS 2003 to SBS 2008 SQL Application Movehttp://192.168.2.20/blogs/doverton/archive/2008/12/08/sql-2005-to-sql-2008-forklift-upgrade-resulted-in-50-cpu-utilisation-amp-resolution-aka-sbs-2003-to-sbs-2008-sql-application-move.aspx#13955Fri, 11 Jun 2010 09:25:53 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:13955David Overton<p>Kael,</p> <p>the migration took a few minutes and the trouble shooting did not take long using the tools. I think I allowed about 10 minutes for the data capture to run.</p> <p>Thanks</p> <p>David</p> <div style="clear:both;"></div><img src="http://192.168.2.20/aggbug.aspx?PostID=13955" width="1" height="1">re: SQL 2005 to SQL 2008 forklift upgrade resulted in 50% cpu utilisation (& resolution) – aka SBS 2003 to SBS 2008 SQL Application Movehttp://192.168.2.20/blogs/doverton/archive/2008/12/08/sql-2005-to-sql-2008-forklift-upgrade-resulted-in-50-cpu-utilisation-amp-resolution-aka-sbs-2003-to-sbs-2008-sql-application-move.aspx#13952Thu, 10 Jun 2010 15:00:53 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:13952Kael<p>Hi David, How long did the migration take and how long for the trouble shooting?</p> <p>Thanks</p> <div style="clear:both;"></div><img src="http://192.168.2.20/aggbug.aspx?PostID=13952" width="1" height="1">