One CPU taking 85-90% utilization

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Try asking them here. x-posted to:microsoft.public.sqlserver.server

http://www.microsoft.com/communitie...6d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

Jitin Batra said:
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.
Click to expand...
Click to expand...
 
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 said:
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 said:
Try asking them here. x-posted to:microsoft.public.sqlserver.server

http://www.microsoft.com/communitie...6d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

Jitin Batra said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top