Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error
SQL error messages, SQL Server 2000, SQL Server 2005, SQL Server migration, SQL Server performance, SQL Server upgrades
My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 4, 2008 1:46 PM
UPDATED:
April 4, 2008 6:22 PM
Answer Wiki:
It's possible that you simply need to rebuild all your indexes.
You'll also want to look at SQL Profiler and see exactly which queries are running the CPU up to 100%.
The optimizer is SQL 2005 has been changed quite a bit and some query retuning may be needed.
Unfortunately this can happen which is why it is recommended that you test everything before doing a version upgrade of your database software (the same applies to Oracle, MySQL, DB2, etc as well).
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
