Home > IT Answers > SQL Server > Migration from SQL Server 2000 to SQL Server 2005
Nitin1983
5 pts.
 Migration from SQL Server 2000 to SQL Server 2005
SQL Server 2000 migration, SQL Server 2005 migration, SQL Server 2005 performance, SQL Server migration
Hi EveryBody, I am new to SQL SERVER 2005, I have migrated my SQL SERVER 2000 database to SQL SERVER 2005 and it has degraded my site performance. A Page that opens in 10 seconds is now opening in 30 seconds. I have updated the STATISTICS of the database using UPDATE STATISTICS command but no gain. I am Wondered the spead is same on my development server but it is decreased on Hosting Server( discountasp.net). Please help

Software/Hardware used:
ASKED: January 29, 2009  4:56 AM
UPDATED: January 29, 2009  7:15 PM
RELATED QUESTIONS
Answer Wiki:
It could be any number of things. The disks on this server could be slower. This SQL 2005 server may have more customers on it than the SQL 2000 server did. I've seen cases when this happens specifically on 32bit hardware because of the changes in the way that SQL SErver 2005 stores the execution plan cache is different from the way that SQL 2000 stores the execution plan cache. You will want to contact your hosting company and see if they have another SQL 2005 server that they can migrate you to.
Last Wiki Answer Submitted:  January 29, 2009  7:15 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _