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 ; but in task manager sqlservr.exe is still taking 99% CPU.
System Configuration: SQL Server 2008 SP1 Microsoft SQL Server 2008 (SP1) - Intel X64) Mar 27 2009; RAM : 4 GB
Please reply to this post as soon as possible.
Thanks in advance.
asked Sep 02, 2010 at 09:06 PM in Default
I would start at what is currently running (sp_who2 is a basic start or the query @ the bottom..).
If it is a specific query causing the problem then look at the execution plan (what indexes are been used etc).
answered Sep 03, 2010 at 12:48 AM
To add to @Jonlee's great advice, you can also open activity monitor and see whats causing the spike in CPU usage(expensive queries, waits etc..) Also instead of relying on task manager you can fire process explorer and see whats really happening in your box overall.
answered Sep 03, 2010 at 06:21 AM