SQLSERVR.exe*32 run at 100% CPU

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.
LVL 2
infedonetworkAsked:
Who is Participating?
 
Olaf De CeusterConnect With a Mentor Commented:
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
 
Olaf De CeusterCommented:
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
 
nsonbatyCommented:
you can always limits the CPU usage of teh SQL server from the inside the server configuration options
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
infedonetworkAuthor Commented:
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
 
Olaf De CeusterCommented:
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
 
infedonetworkAuthor Commented:
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
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.