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.

SenthilYou 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...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--------

"Senthil" <senthil_tamil@.yahoo.com> wrote in message
news:46b4744a.0307111624.594a0159@.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