?
Solved

Very High CPU Usage

Posted on 2008-09-30
6
Medium Priority
?
1,164 Views
Last Modified: 2012-05-05
I am running SCE 2007 SP1. I have not imported any managment packs and this was a clean install.

However the CPU on the server where SCE 2007 is installed is running at 100% for approx 22 hours of the day. It rarely drops down below 40%. The server is running Windows Server 2003 SP2 with SQL 2005 Express. All Service Packs are installed

Any solutions out there to this problem. I have read some of the forums, applied hot fixes but the problem is just not going away
 
0
Comment
Question by:SACUADMIN
[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 16

Expert Comment

by:JoWickerman
ID: 22604591
Hi,

If you open Task Manager, click on Processes, select the "Show processes from all users" and sort by CPU usage, what is the main process utilizing the CPU?
0
 

Author Comment

by:SACUADMIN
ID: 22604774
SQLServer.exe and HealthService.exe
0
 
LVL 16

Expert Comment

by:JoWickerman
ID: 22604891
What is the size and layout of your harddrives? RAID?
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

Author Comment

by:SACUADMIN
ID: 22604987
SAS Array 1 = 68GB (Raid 1+0)
SAS Array 2 = 280GB (Raid 5)
0
 

Accepted Solution

by:
SACUADMIN earned 0 total points
ID: 22625357
Disable Auto Discovery and the problem seems to have gone away
0
 

Expert Comment

by:DSF_DK
ID: 24268544
I have the same problem. Exept I already have Auto Discovery disabled. The SQLserver.exe rarely drops below 100%. It is a 6 month old build that I have updated with the latest MP's for AD, Citrix and IBM H/W.

Any idears?

/Thomas
0

Featured Post

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

Question has a verified solution.

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

The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
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