Steps to do CPU Investigation

Question

Steps to do CPU Investigation

madhu-686862

SSChampion

Points: 10707
More actions
June 3, 2008 at 9:45 am

#122518

Hi,
could you please tell me the steps to investigate cpu utilization for a particular server?
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

Are you trying to find out why CPU is being used by the SQL Server? Then you can start with running a profiler with filter on CPU (let us say show me all queries that take more than 500). From that you will be able to know which query is using up high CPU.

-Roy

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 2

Start by looking in perfmon at the CPU counters.

If you already know you're having CPU issues, you can look in master.sys.sysprocesses to see which processes are using the most CPU. However, if this is a sustained issue where it's not happening just at specific times, then perfmon is the way to go. And if it's not happening all the time, then use perfmon and profiler to correlate the times and see what was going on when the CPU was high. Then you can look at the processes to see if they can be optimized.

If you have any more specific questions I'd be glad to help, but this is a good start I hope.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

Is this a general CPU problem or a specific one?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Rao.V Hall of Fame Points: 3452 More actions · Answer 4

Hi all....

The above methods wats mentioned are good in finding out the CPU utilization.Can anyone advice me how i can monitor all the processes consuming CPU usage continuously (by the use of some job scheduled to execute a procedure which determines the CPU usage)and can keep some threshold like 70% and if CPU usage crosses that threshold I should be able to get an alert.

Thanks in Advance...

Vinay