SQL Server 2008 R2 SP3 High CPU Usage

There is a weird SQL Server 2008 R2 SP3 issue needs your help.

I have a SQL Server 2008 R2 with SP2 and other security patches on date. Normally, the CPU average loading is around 30% to 40%. Recently, I deployed SP3. After that, I found server CPU usage keeps in very high watermark, most time keeping on 100%. I checked the server from several different ways, there is no expensive queries or system status changes. During the troubleshooting, I found all regular queries spend more CPU resources than before. Once, I uninstalled SP3, everything goes well again.

Do you have the similar experience before? Or advice?
rsp_itAsked:
Who is Participating?
 
Naitik GamitSoftware DeveloperCommented:
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
That's weird.
Did you try to install back the SP3 or you still let it with SP2?
0
 
rsp_itAuthor Commented:
Naitik,

Thank you for your reply. I need time to try the article you mentioned. If I can find some helpful information, that will be great.
0
 
rsp_itAuthor Commented:
Vitor,

Install back the SP3 is one of my next step to try. However, this server is one of my critical server, so, it is not easy to find so many maintenance window. I suppose to do it about 2 month later when I have enough time to complete queries and codes double checking
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Here where I'm working we have a maintenance window by quarter so I understand that.
Well, I hope that whatever was the reason that will disappear in 2 months :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.