We help IT Professionals succeed at work.

SQL 2000 Query

Medium Priority
367 Views
Last Modified: 2012-08-17
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?
Comment
Watch Question

CERTIFIED EXPERT
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

Explore More ContentExplore courses, solutions, and other research materials related to this topic.