CPU usage 100% Resources failed

I have a server that Windows 2000 Advanced Server that is
clustered (Active/Active) with SQL Server 2000 with SP3A.
There are periods when the server CPU usage can be at 100%
for 30 minutes or longer.
What some of the resources that should fail when the CPU
usage is at this rate for an extended period of time?
Thanks,
Mike
Mike, you are losing me here. The system get pegged at 100% CPU and you want
to know what?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:2910d01c464e9$6b435970$a401280a@.phx.gbl...
> I have a server that Windows 2000 Advanced Server that is
> clustered (Active/Active) with SQL Server 2000 with SP3A.
> There are periods when the server CPU usage can be at 100%
> for 30 minutes or longer.
> What some of the resources that should fail when the CPU
> usage is at this rate for an extended period of time?
> Thanks,
> Mike
|||failover will only happen when the heartbeat fails.
100% CPU doesn't mean that failover will happen.
"Rodney R. Fournier [MVP]" wrote:

> Mike, you are losing me here. The system get pegged at 100% CPU and you want
> to know what?
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "Mike" <anonymous@.discussions.microsoft.com> wrote in message
> news:2910d01c464e9$6b435970$a401280a@.phx.gbl...
>
>
|||some of the resources that can fail when cpu usage is 100%?
Well if SQL Server cannot reply to the IsAlive queries than SQL Server resource can fail.
What resources fail in your case?
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

CPU usage (HIGH, MEDIUM, LOW)

I have a Windows 2000 Advanced Server with SQL Server
2000 Enterprise Edition with SP3A.
The server has approximately 300 users and CPU usage
stays
states between 90 to 100 % for at least 200 minutes out
of a 12 hour processing windows in time.
What is a good metric for LOW, MEDIUIM, and HIGH CPU
usage rates.
Thanks,
Mark
Hi,
90-100% for more than 3 hours will be a problem. Idetify the process (might
be batch) causing the bottle neck.
If you find that there is no much optimization can be done in your program ,
probably go for 1 more additional CPU.
Low : Less than 20%
Medium : Between 21 % to 60%
High : Any thing above 60%
Thanks
Hari
MCDBA
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:222e501c45d80$90292870$a601280a@.phx.gbl...
> I have a Windows 2000 Advanced Server with SQL Server
> 2000 Enterprise Edition with SP3A.
> The server has approximately 300 users and CPU usage
> stays
> states between 90 to 100 % for at least 200 minutes out
> of a 12 hour processing windows in time.
> What is a good metric for LOW, MEDIUIM, and HIGH CPU
> usage rates.
> Thanks,
> Mark
>
>
|||Hi,
90-100% for more than 3 hours will be a problem. Idetify the process (might
be batch) causing the bottle neck.
If you find that there is no much optimization can be done in your program ,
probably go for 1 more additional CPU.
Low : Less than 20%
Medium : Between 21 % to 60%
High : Any thing above 60%
Thanks
Hari
MCDBA
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:222e501c45d80$90292870$a601280a@.phx.gbl...
> I have a Windows 2000 Advanced Server with SQL Server
> 2000 Enterprise Edition with SP3A.
> The server has approximately 300 users and CPU usage
> stays
> states between 90 to 100 % for at least 200 minutes out
> of a 12 hour processing windows in time.
> What is a good metric for LOW, MEDIUIM, and HIGH CPU
> usage rates.
> Thanks,
> Mark
>
>

CPU usage (HIGH, MEDIUM, LOW)

I have a Windows 2000 Advanced Server with SQL Server
2000 Enterprise Edition with SP3A.
The server has approximately 300 users and CPU usage
stays
states between 90 to 100 % for at least 200 minutes out
of a 12 hour processing windows in time.
What is a good metric for LOW, MEDIUIM, and HIGH CPU
usage rates.
Thanks,
MarkHi,
90-100% for more than 3 hours will be a problem. Idetify the process (might
be batch) causing the bottle neck.
If you find that there is no much optimization can be done in your program ,
probably go for 1 more additional CPU.
Low : Less than 20%
Medium : Between 21 % to 60%
High : Any thing above 60%
Thanks
Hari
MCDBA
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:222e501c45d80$90292870$a601280a@.phx
.gbl...
> I have a Windows 2000 Advanced Server with SQL Server
> 2000 Enterprise Edition with SP3A.
> The server has approximately 300 users and CPU usage
> stays
> states between 90 to 100 % for at least 200 minutes out
> of a 12 hour processing windows in time.
> What is a good metric for LOW, MEDIUIM, and HIGH CPU
> usage rates.
> Thanks,
> Mark
>
>

CPU usage (HIGH, MEDIUM, LOW)

I have a Windows 2000 Advanced Server with SQL Server
2000 Enterprise Edition with SP3A.
The server has approximately 300 users and CPU usage
stays
states between 90 to 100 % for at least 200 minutes out
of a 12 hour processing windows in time.
What is a good metric for LOW, MEDIUIM, and HIGH CPU
usage rates.
Thanks,
MarkHi,
90-100% for more than 3 hours will be a problem. Idetify the process (might
be batch) causing the bottle neck.
If you find that there is no much optimization can be done in your program ,
probably go for 1 more additional CPU.
Low : Less than 20%
Medium : Between 21 % to 60%
High : Any thing above 60%
--
Thanks
Hari
MCDBA
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:222e501c45d80$90292870$a601280a@.phx.gbl...
> I have a Windows 2000 Advanced Server with SQL Server
> 2000 Enterprise Edition with SP3A.
> The server has approximately 300 users and CPU usage
> stays
> states between 90 to 100 % for at least 200 minutes out
> of a 12 hour processing windows in time.
> What is a good metric for LOW, MEDIUIM, and HIGH CPU
> usage rates.
> Thanks,
> Mark
>
>

CPU Maxed out by sql server 2k sp3a

Hi all,
I'm having a problem, that curiously enough, a few people
are experiencing but so far I haven't found an answer for
it:
I have two different servers running sql server 2000 sp3:
- IBM P III 800 Mhz 1 Gb RAM, RAID 5 win 2k advanced
server.
- DELL pe 2650 Xeon 2.0 Ghz 512 Mb RAM, RAID 5 win 2k
advanced
The same stored procedure that returns a 100 record page
out of an ~27000 set takes a fraction of a second in the
first system and around 4 min in the second!. The CPU
usage in the second system goes to full during the whole
time whereas in the first it shows just a small peak ~30%.
In both systems, memory usage remains minimum.
I've used the performance monitor for both systems and so
far have not found big differences.
Any suggestions, help will be really appreciated.
Thanks
JorgeA fill factor of 20%? Or do you mean 80%? 20% full is an awful lot of
room to leave empty on a page. In either case I suspect it was not the
fact that you reindexed the table but more that the statistics were updated
as a result of the reindexing. When ever you move or restore data you
should always update the statistics. See sp_updatestats and UPDATE
STATISTICS in BooksOnLine.
--
Andrew J. Kelly
SQL Server MVP
"Jorge" <jflores@.savvydata.com> wrote in message
news:0a3301c34d18$45a968b0$a501280a@.phx.gbl...
> Hello Andrew, Thank you for your response.
> I had not looked at the execution tree of both machines
> before because everything was the same on them... my
> mistake! Now, after a recreation of my clustered index
> with a fill factor of 20% everything is back to normal.
> Again thank you, you saved me a trip to the server
> collocation space an a few gray hairs!
> >--Original Message--
> >Have you looked at the query plan for both to see what is
> different? I
> >suspect the second is doing full table scans where as the
> first is using an
> >index seek. Have you updated the statistics on the
> second machine?
> >
> >--
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"Jorge" <jflores@.savvydata.com> wrote in message
> >news:06d301c34c3a$adb48950$a501280a@.phx.gbl...
> >> Hi all,
> >> I'm having a problem, that curiously enough, a few
> people
> >> are experiencing but so far I haven't found an answer
> for
> >> it:
> >> I have two different servers running sql server 2000
> sp3:
> >> - IBM P III 800 Mhz 1 Gb RAM, RAID 5 win 2k advanced
> >> server.
> >> - DELL pe 2650 Xeon 2.0 Ghz 512 Mb RAM, RAID 5 win 2k
> >> advanced
> >>
> >> The same stored procedure that returns a 100 record page
> >> out of an ~27000 set takes a fraction of a second in the
> >> first system and around 4 min in the second!. The CPU
> >> usage in the second system goes to full during the whole
> >> time whereas in the first it shows just a small peak
> ~30%.
> >> In both systems, memory usage remains minimum.
> >> I've used the performance monitor for both systems and
> so
> >> far have not found big differences.
> >> Any suggestions, help will be really appreciated.
> >> Thanks
> >>
> >> Jorge
> >
> >
> >.
> >|||Again, you're right. And 80% is what I ment.
Thanks
>--Original Message--
>A fill factor of 20%? Or do you mean 80%? 20% full is
an awful lot of
>room to leave empty on a page. In either case I suspect
it was not the
>fact that you reindexed the table but more that the
statistics were updated
>as a result of the reindexing. When ever you move or
restore data you
>should always update the statistics. See sp_updatestats
and UPDATE
>STATISTICS in BooksOnLine.
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Jorge" <jflores@.savvydata.com> wrote in message
>news:0a3301c34d18$45a968b0$a501280a@.phx.gbl...
>> Hello Andrew, Thank you for your response.
>> I had not looked at the execution tree of both machines
>> before because everything was the same on them... my
>> mistake! Now, after a recreation of my clustered index
>> with a fill factor of 20% everything is back to normal.
>> Again thank you, you saved me a trip to the server
>> collocation space an a few gray hairs!
>> >--Original Message--
>> >Have you looked at the query plan for both to see what
is
>> different? I
>> >suspect the second is doing full table scans where as
the
>> first is using an
>> >index seek. Have you updated the statistics on the
>> second machine?
>> >
>> >--
>> >
>> >Andrew J. Kelly
>> >SQL Server MVP
>> >
>> >
>> >"Jorge" <jflores@.savvydata.com> wrote in message
>> >news:06d301c34c3a$adb48950$a501280a@.phx.gbl...
>> >> Hi all,
>> >> I'm having a problem, that curiously enough, a few
>> people
>> >> are experiencing but so far I haven't found an answer
>> for
>> >> it:
>> >> I have two different servers running sql server 2000
>> sp3:
>> >> - IBM P III 800 Mhz 1 Gb RAM, RAID 5 win 2k advanced
>> >> server.
>> >> - DELL pe 2650 Xeon 2.0 Ghz 512 Mb RAM, RAID 5 win 2k
>> >> advanced
>> >>
>> >> The same stored procedure that returns a 100 record
page
>> >> out of an ~27000 set takes a fraction of a second in
the
>> >> first system and around 4 min in the second!. The CPU
>> >> usage in the second system goes to full during the
whole
>> >> time whereas in the first it shows just a small peak
>> ~30%.
>> >> In both systems, memory usage remains minimum.
>> >> I've used the performance monitor for both systems
and
>> so
>> >> far have not found big differences.
>> >> Any suggestions, help will be really appreciated.
>> >> Thanks
>> >>
>> >> Jorge
>> >
>> >
>> >.
>> >
>
>.
>|||Brian,
If you have read the other threads you probably know by
now that I solved my problem. Nevertheless, in the
process, while I suspected my Dell server, I found out
that there were a few BIOS and controller updates Dell had
come up with in a relatively short time, and I didn't know
about them. If you haven't by now, take a look at any
updates for your server. Just wanted to give you the heads
up, hope this helps.
Good Luck!
>--Original Message--
>Jorge,
> This is going to sound strange, but I am haveing the
>same problem. I have 2 servers running with the same
data
>on them sql server 2000 sp3 win2k, and the older one is
>running fine but the new Dell 2600 2G Ram, Xeon processor
>has a bad memory leak. The systems should be exactly the
>same, but the one server will stop responding at various
>times through the day, and the only way to get it back up
>is to restart the machine. I am guessing they are not
>related just because of the simularities of the machines,
>but maybe there is something to it.
>.
>