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

SQL server usage

At certain times of the day our server with sql server 2000 on it will jump up to 50% usage on the cpu.  When I look at the taskmanager it says that SQL server is usage 50%.  Can I get a more detailed look to see what in sql server is making it leap up so high?
2 Solutions
One of the best monitors for SQL I have ever used is Spotlight on SQL from Quest Software. It is expensive but they do offer a 30 day trial. You might check that out.

A free alternative is checking the sysprocesses table.


Sometimes, SQL Server will churn when it is doing a rollback.  Also, occassionally, if there have been a lot of deletes to a database table, SQL Server will kick off a process to clean out the data and index spaces and reorganize them.  That can use up a lot of CPU.

I use a slightly modified version of sp_who2 to display all running process id's and you can see if any of these things are active at the time you're having problems.
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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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