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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Naitik GamitSoftware DeveloperCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.