August 23, 2003 at 3:37 am
We have a production system implemented on sql 2000,service pack:sp3.
What we observe is that the CPU usage is 100% most of the time even if no time activity is happening on the database.
What may be the reason?
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
August 24, 2003 at 8:42 am
What process is running near 100%? Is it SQL Server? You can check this using task manager or through Perfmon (Process counters).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
August 24, 2003 at 11:19 pm
Yes it is SQL Server that is runing near 100%.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
August 25, 2003 at 12:05 am
Looking at sysprocesses, does one or more SPIDs seem to be hogging most of the resources?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
August 25, 2003 at 12:12 am
I checked the sysprocess table and none of the spids seem to do so.
One thing I forgot to mention is that sql2000 is on NT4 Server.Will I benefit by switching to winddows server2000? My Server Administrator is skeptic about shifting from NT4.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
August 25, 2003 at 1:59 am
Did you check the cpu and the physical_io columns in the sysprocess table?
Also did you check if you have enough memory to handle SQLServer as well as the OS (and other apps running beside SQLServer).
What is the chache hit ratio and the target/total server memory
Just have a look on the sysperfinfo table for that.
Do your server make swapping?
Or even did you check if you have no attack or virus?
And beside all of this I would definitly recommend to upgrade to W2K or even W2K3. MS doesn't support any more NT4 (no patch, no nothing! The only exception was the patch #026 against the W32.Blaster worm).
But in this specific case that one should not be the problem
Bye
Gabor
Bye
Gabor
August 25, 2003 at 6:50 am
quote:
And beside all of this I would definitly recommend to upgrade to W2K or even W2K3. MS doesn't support any more NT4 (no patch, no nothing! The only exception was the patch #026 against the W32.Blaster worm).But in this specific case that one should not be the problem
Actually, MS extended patch support (again) for NT4. However, I would suggest switching as well. For standard servers (non-domain controllers), the switch is a no-brainer.
Joe Johnson
Joe Johnson
NETDIO,LLC.
August 25, 2003 at 7:33 am
If you've looked at everything else. Try this. We had the same problem. It turned out to be a pif file. Not sure if was meant to be a virus, but someone had filled that file with a lot of "trash", just lines repeating themselves. Whenever someone would view the folder in explorer the CPU usage would shoot to 100%. In task manager it showed that CPU was hogged by explorer. Good luck.
Curtis Smith
Application Dev. Mgr
DBA
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply