One CPU taking 85-90% utilization

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jitin Batra - 06 Aug 2007 05:44 GMT

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.

Reply to this Message

Dave Patrick - 06 Aug 2007 15:41 GMT

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

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&c
r=US

Signature

Regards,

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

>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
[quoted text clipped - 9 lines]
> could
> not understand what it says. Please help.

Reply to this Message

Geoff N. Hiten - 06 Aug 2007 16:30 GMT

That could be your NIC activity. Check the DPC rate on that processor.
DPCs are mostly associated with network driver activity.

Signature

Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

> Try asking them here. x-posted to:microsoft.public.sqlserver.server
>
[quoted text clipped - 14 lines]
>> could
>> not understand what it says. Please help.

Reply to this Message

Jitin Batra - 07 Aug 2007 03:08 GMT

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

> That could be your NIC activity. Check the DPC rate on that processor.
> DPCs are mostly associated with network driver activity.
[quoted text clipped - 17 lines]
> >> could
> >> not understand what it says. Please help.

Reply to this Message