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 |
|
Martyn123
Starting Member
29 Posts |
 Posted - 2010-09-02 : 23:48:16
|
| Hi, I have read the topics "High memory utilization etc " on this forum and I tried it out to resolve the issue but unfortunately the issue still remains unsolved.I have been facing this problem when I start SQLServer it is taking 99% CPU utilization. I have p2p replication configured on it and some services running against SQLServer initially I thought the issue is bcos of replication agents and services but even after stopping all services and disabling all replication activities and even SQLServer agent is stopped so no chance of any jobs running under SQL Server agent, still when I see in task manager sqlservr.exe is utilizing 99% CPU. I have enabled the profiler trace and when I start one the services, under CPU column in profiler trace it is showing 10-16 % CPU ; in task manager sqlservr.exe is taking 99% CPU. System Configuration: SQL Server 2008 SP1Microsoft SQL Server 2008 (SP1) - Intel X64) Mar 27 2009;RAM : 4 GBPlease reply to this post as soon as possible.Thanks in advance.Martyn |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Martyn123
Starting Member
29 Posts |
Posted - 2010-09-04 : 04:14:44
|
| Thank you very much Tara Kizer for your immediate reply, it helped me a lot to narrow my search on indexing and finally I could resolve the issue and it was due to poor indexing. Thank again. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
High CPU utilization by sqlservr.exe