Monday, February 18, 2013 12:48 PM
I just upgraded one of production servers from SQL SERVER 2008 to 2008 R2. The server exhibited increasingly high CPU culminating in all 8 CPUs being 100% utilized when SQL SERVER executed one of scripts. These scripts ran everyday successfully before upgrade, and I could not figure out why it leads to CPU 100%, anyone can help me for this?
The server information is :
OS: Win Server 2003 R2 x64, CPU:8, Memory: 64GB.
Monday, February 18, 2013 12:57 PM
Monday, February 18, 2013 1:00 PMModerator
It is recommended to defrag indexes and update statistics when you upgrade to a new version of SQL Server.
Hope this helps
Monday, February 18, 2013 6:21 PM
<> Make sure the database involved are having updated statistics with full scan:
Exec sp_MSForEachtable 'UPDATE STATISTICS ? WITH FULLSCAN'
<> Also if you know the queeries which are causing high CPU, try using MAXDOP query hint, see if it helps.
<> Also confirm in performance monitor/task manager, sqlservr.exe is consuming high CPU.