April 26, 2010 at 6:55 am
Hello All,
Good Morning.
We are moving database from SQL Server 2000 with windows 2000 to sql 2005 with windows 2008. After I have restored the backup on the new server, it is showing 100% CPU usage when running the processes. Can you assist me troubleshooting this issue? I checked for service packs and they are the comaptible ones.
April 26, 2010 at 7:11 am
There are a good number of things that can cause high CPU usage.
What steps have you taken already to troubleshoot the issue? Can you provide more details on how the server is configured (hardware, virtual/physical sever, etc)?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 26, 2010 at 7:36 am
You really need to identify what's causing the issue. One thing that does occur after an upgrade is that the statistics for every index are rebuilt as they are accessed. That's why it's recommended to update the statistics manually after the upgrade. This could be part of the cause, but without a lot more information, that's just a silly guess.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply