473,387 Members | 1,423 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 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 1929
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: anon | last post by:
I am trying to stress test the effects of SSL on a web server using Web Application Stress Tool (WAST). However, when using SSL and according to the WAST Help files, the peformance HIT is in the...
182
by: Jim Hubbard | last post by:
http://www.eweek.com/article2/0,1759,1774642,00.asp
13
by: Pieter | last post by:
Hi, Maybe a little bit off-topic, but it still seemd the best place to ask for it :-) I'm planning to buy a new development laptop, and I would like to buy an AMD, Dual Core,-bit But none of...
11
by: John S | last post by:
I'm writing a VB.Net 1.1 app that has to listen for messages coming to it via TCP/IP. When one arrives it it queued and then processed on a seperate thread while the main thread goes back to...
5
by: NonNB | last post by:
Apols for the post here, but there is no public.inetserver.cassini Is there a way to configure the cassini / ASP NET Development web server: 1) So that the port can be pegged (seems to be...
7
by: Frank Rizzo | last post by:
Hello, I have a 32-bit .net 1.1 service that spawns many different threads and, in general, does a lot of processing. Up to now, it's been working on Win2003 32-bit servers fairly well against...
33
by: klaushuotari | last post by:
C rocks the world. Plain and simple. It's the ultimate solution, period. Screw C++ and all the other ultra-high-level languages. If one can't achieve in C what he wants, then he's obviously not up...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.