Solved

SQLSERVR.exe*32 run at 100% CPU

Posted on 2010-11-24
6
2,610 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
  • 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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 500 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

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
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 show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now