Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error

Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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).

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following