Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-09-02 : 07:06:06
|
| I have SQL Server 2005 Enterprise Edition with SP3. All of a sudden, I have started seeing 100% CPU utilization by process sqlservr.exe. When I stop all SQL Server services, then CPU usage returns to normal. Even when one of the services is running, the CPU usage is again 100%.I have been searching google pages for days but cannot find a way to resolve it. Has anyone ever seen this before? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-09-02 : 11:39:02
|
| What are your Server Specs??? CPU,Memory and Disk.... |
 |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-09-02 : 11:59:44
|
| It's meant for testing customer issues, not at all heavy load. It has just 3-4 databases of very small size. It is a VM and its specs are: 4G RAM, Intel Xeon E5520 @2.27 GHz and ample free space. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-09-02 : 12:04:52
|
| So how many CPU?? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-02 : 12:59:12
|
| you are probably missing indexes. create a trace to capture the most expensive queries. then optimize them.can also look at the built-in standard reports for top queries by cpu time |
|
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-09-02 : 13:11:13
|
| I was able to correct it merely by deleting a non-required database having 12 GB transaction log.Thanks sodeep anyways! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-02 : 13:21:17
|
| how does dropping a database fix cpu problems?i suspect you haven't found the problem yet |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
sqlservr.exe is using 100 percent CPU