Which DB Process Is Taking CPU?

[gharabed]

I have a database server whose CPU is constantly above 75% utilization and frequently pegs at 100%. How do you tell within SQL Server how much cpu is being utilized by each database process?

 

[onpnt]

what version of SQL Server?

You ahve ruled out other things causing the CPU usage correct?


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[gharabed]

Sorry...SQL Server 2000

 

[onpnt]

in enterprise manager

Expand the server you want to check
Expand management
Expand Currenty Activity
Select Process Info


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[onpnt]

should mention. The CPU column you see will be in time of usage and that is in milliseconds


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[timscronin]

Might try running profiler during this time and capture events. To look at what to capture goto

http://www.sql-server-performance.com/sql_server_profiler_tips.asp