471,084 Members | 1,024 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

One CPU out of 32 pegged to 85%

Hey All,

We are running sql 2000 on 32 processor box. It is so weird that
around 4:30 PM every day one CPU spikes upto 85-90%. It continues to
go like that until rest of the day. We checked for jobs that will
start around that time but no luck. Only thing that we doubt now is a
job that starts around 2:30 pm. The job GZIPs the trace file from the
server and copies it to another server. Still, whats confusing is the
job starts around 2:30 PM but cpu spike starts around 4 PM. Can
someone tell me how can I find out what is running on that particular
processor.

Thanks for your help in advance.

Senthil
Jul 20 '05 #1
1 1891
You might try using Performance Monitor. Select Process / % Processor
Time / All instances. This will help identify the EXE consuming the
processor.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Senthil" <se***********@yahoo.com> wrote in message
news:46**************************@posting.google.c om...
Hey All,

We are running sql 2000 on 32 processor box. It is so weird that
around 4:30 PM every day one CPU spikes upto 85-90%. It continues to
go like that until rest of the day. We checked for jobs that will
start around that time but no luck. Only thing that we doubt now is a
job that starts around 2:30 pm. The job GZIPs the trace file from the
server and copies it to another server. Still, whats confusing is the
job starts around 2:30 PM but cpu spike starts around 4 PM. Can
someone tell me how can I find out what is running on that particular
processor.

Thanks for your help in advance.

Senthil

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

182 posts views Thread by Jim Hubbard | last post: by
11 posts views Thread by John S | last post: by
5 posts views Thread by NonNB | last post: by
7 posts views Thread by Frank Rizzo | last post: by
33 posts views Thread by klaushuotari | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.