Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Huge cost issue with Temp DB using 2008r2 sp2 RE: Huge cost issue with Temp DB using 2008r2 sp2

  • November 9, 2012 at 3:56 am

    #1557534

    What post-migration steps have you carried out on the new server?

    I am guessing you backed up and restored the 2005 database onto the 2008 server?

    Did you run DBCC UPDATEUSAGE, rebuild and update all statistics?