One CPU taking 85-90% utilization

Jitin Batra · External Since: Aug 05, 2007 Posts: 2

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.

Dave Patrick · External Since: Oct 18, 2005 Posts: 3525

Try asking them here. x-posted to:microsoft.public.sqlserver.server

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=...rosoft.

--

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.

Geoff N. Hiten · External Since: Aug 06, 2007 Posts: 1

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 RemoveThis @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
>
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=...rosoft.
>
> --
>
> 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.
>

Jitin Batra · External Since: Aug 05, 2007 Posts: 2

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
_Total 0 1

% DPC Time 0.630 0.727 0.532

% Interrupt Time 35.095 0.143 70.047

% Privileged Time 39.516 7.479 71.553

% Processor Time 43.820 15.074 72.566

% User Time 4.304 7.595 1.013

APC Bypasses/sec 537.979 238.574 299.405

DPC Bypasses/sec 0.000 0.000 0.000

DPC Rate 13.000 5.000 8.000

DPCs Queued/sec 614.149 311.553 302.596

Interrupts/sec 157336.766 77643.012 79693.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.TakeThisOut@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
> >
> > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=...rosoft.
> >
> > --
> >
> > 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.
> >
>
>