SQL 2000 Query

I have a SQL 2000 server that keep hammering the CPU at 80-90%. Is there a query I can run that will tell me exactly what the SQL service is doing at the time of High CPU performance?
LVL 1
DKHeneryAsked:
Who is Participating?
 
Tony303Connect With a Mentor Commented:
Hi,

You'll have to use SQL Profiler.

Can you "make" the CPU spike up? IE. is it doing it when you run XYZ process?
Does it happen at when you have scheduled your hourly log backups? (usually on the hour perhaps).

So, the key is to run a trace, wait till you see the 90 to 100 % cpu spike on the the Server Task Manager, then stop the trace and look at the data it has produced....time consuming sorry.

This article is helpful.

http://support.microsoft.com/kb/224587
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.