One CPU taking 85-90% utilization

Try asking them here. x-posted to:microsoft.public.sqlserver.server
[url]http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server& cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US[/url]
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Jitin Batra" wrote:
>I have a sql server which has correct affinity set but generating high cpu
> utilization on one of the CPU's. This is a HP Proliant DL 580 series
> server.
> kernrate tool shows ntoskrnl.exe with the highest hits. How can I find if
> there is a poor written driver which is generating these high interrupts
> like
> Nic card. I have enabled verifier.exe for nic driver and will reboot this
> weekend to see what it shows. if you have any other suggestion, then
> please
> let me know soon caus I cannot reboot this server during week days. I have
> also tried adplus to dump services.exe and sqlserve.exe processes but
> could
> not understand what it says. Please help.
That could be your NIC activity. Check the DPC rate on that processor.
DPCs are mostly associated with network driver activity.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:6BE0EF01-8FD5-4B22-876D-78B0DB2FDE2A@.microsoft.com...
> Try asking them here. x-posted to:microsoft.public.sqlserver.server
> [url]http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server& cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US[/url]
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Jitin Batra" wrote:
>
|||This is the perfmon stats for processor which shows DCP time is regularly
switching between P0 and P1 and there is not much diff in DPC rate. Interrupt
time and processor time is what shows quiet high for P1.
Processor
_Total01
% DPC Time0.6300.7270.532
% Interrupt Time35.0950.14370.047
% Privileged Time39.5167.47971.553
% Processor Time43.82015.07472.566
% User Time4.3047.5951.013
APC Bypasses/sec537.979238.574299.405
DPC Bypasses/sec0.0000.0000.000
DPC Rate13.0005.0008.000
DPCs Queued/sec614.149311.553302.596
Interrupts/sec157336.76677643.01279693.754
"Geoff N. Hiten" wrote:

> That could be your NIC activity. Check the DPC rate on that processor.
> DPCs are mostly associated with network driver activity.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
> news:6BE0EF01-8FD5-4B22-876D-78B0DB2FDE2A@.microsoft.com...
>

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