?
Solved

SQLSERVR.exe*32 run at 100% CPU

Posted on 2010-11-24
6
Medium Priority
?
2,654 Views
Last Modified: 2012-05-10
Hi

I have a Windows 2008 SBS 64 bit virtual server and I can't figureout why the sqlservr.exe*32 run at 100% CPU for long time.
0
Comment
Question by:infedonetwork
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 22

Expert Comment

by:Olaf De Ceuster
ID: 34211052
Did you run the SBS BPA to npin point any obvious problems?
http://www.microsoft.com/downloads/en/details.aspx?familyid=86a1aa32-9814-484e-bd43-3e42aec7f731&displaylang=en
Hope that helps,
Olaf
0
 
LVL 6

Expert Comment

by:nsonbaty
ID: 34211204
you can always limits the CPU usage of teh SQL server from the inside the server configuration options
0
 
LVL 2

Author Comment

by:infedonetwork
ID: 34211381
I run the SBS BPA and I fix the few errors it found.
Only one remaining is to upgrade Exchange 2007 from SP1 to SP3.
The SQLSERV.exe is not running continusly. It run sometimes for 1  hour then it stop.
Now the CPU is running between 2 and 5%
0
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 22

Expert Comment

by:Olaf De Ceuster
ID: 34211714
SP3 update will make a few more improvements.
Make sure to disable all Anti-Virus services and stop the Windows SBS Manager service before running the SP3 update. Can take up to one hour.
It won't ask, but restart server after update. It will restart the services you stopped automatically.
You should be all good after that.
Good Luck
Olaf
0
 
LVL 2

Author Comment

by:infedonetwork
ID: 34212952
I Try to run it but I get an erorr saying something about rundll32 be in use.
I did stop all exchange services before but it did not help.
I have to figureout why/
0
 
LVL 22

Accepted Solution

by:
Olaf De Ceuster earned 2000 total points
ID: 34214532
You don't stop the Exchange services.
You do need to stop the Anti-Virus system you use. (Whatever that is) and Windows SBS MAnager service.
If the exchange services are turned off the update will fail because the updater thinks you do not have exchange installed.
Please also restart Server before the update.
Hope that makes sense.
Olaf
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question