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
Brad Marsh
Say Hey Kid
Points: 704
More actions
November 12, 2012 at 2:21 am
#1558057
Sure here we go
2 files
1. 2005 - fast.sqlplan - this the old 2005 server
2. 2008r2 - Slow.sqlplan - This is the new server, now with TempDB the auto create and update stats now on.