Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

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?
1 Solution

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.


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now