x

High CPU utilization by sqlservr.exe

Hi,

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.

more ▼

asked Sep 02, 2010 at 09:06 PM in Default

avatar image

abdul samad
1 2 3 3

did you checked using windows system monitor tool?

Sep 02, 2010 at 09:29 PM Cyborg
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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).

Then run the scripts from @GlennBerrys collect Diag Scripts

 SELECT *
 FROM sys.dm_exec_requests a
 OUTER APPLY sys.dm_exec_sql_text(a.sql_handle) b
 WHERE session_id > 50
 and session_id <> @@spid
more ▼

answered Sep 03, 2010 at 12:48 AM

avatar image

sp_lock
10.8k 27 37 37

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Sep 03, 2010 at 06:21 AM

avatar image

DaniSQL
4.9k 33 39 43

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2207

asked: Sep 02, 2010 at 09:06 PM

Seen: 9091 times

Last Updated: Sep 02, 2010 at 09:06 PM

Copyright 2018 Redgate Software. Privacy Policy