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

Tags:
Microsoft SQL Server 2000
SQL error messages
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.

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.

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

Following

Share this item with your network: