?
Solved

SQL server usage

Posted on 2008-10-02
2
Medium Priority
?
212 Views
Last Modified: 2012-05-05
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?
0
Comment
Question by:ThomasBallardIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
CAGdorf earned 600 total points
ID: 22625380
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.

http://msdn.microsoft.com/en-us/library/aa260456(SQL.80).aspx

0
 
LVL 18

Assisted Solution

by:mdougan
mdougan earned 150 total points
ID: 22625581
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.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question