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...
>