Solved

Very High CPU Usage

Posted on 2008-09-30
6
1,151 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
  • 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 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

22 Experts available now in Live!

Get 1:1 Help Now