Re: CPU Usage

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris Kuske (chris_at_solidoak.com)
Date: 09/03/04 

Date: Fri, 03 Sep 2004 13:26:42 -0700

Following up on the perfmon stuff...

Disk Write Time percentage is about 3% during a insertion run, total
disk time is about 9% during selects. CPU Max is always 25.00 %

BTW, the select run that never goes over 25% is in a stored procedure.
Stored Procedure compilations and recompilations aren't even
registering. The only thing I can see is a issue would be the number of
Lock Requests in SQL server per second. The max I hit is 90,000 when
it's really busy.

Chris Kuske wrote:

> Some selects could be faster... we're running some selects that take
> about 30 seconds (which may be OK, but I want my money's worth from
> those CPUs! :) ). Having a limit that it *NEVER* goes over just seems
> suspicious to me. I'll monitor Perfmon for awhile as Andrew suggested,
> and let you know if anything shows up. The discs don't seem to be
> thrashing around so I'm not sure if it's a I/O problem, but you never
> know...
>
> What I keep thinking is that (100% one 1 cpu / 4 cpus) = 25%. If SQL
> server is somehow working with only really using 1 of the 4, that seems
> like something to look into. I'll check the more obvious stuff first,
> though.
>
> Narayana Vyas Kondreddi wrote:
>
>> If your COU is not going beyond 25% then you should be happy about it :-)
>> But you aren't. So, is something running slow? What makes you worry about
>> your CPU utilization?

Quantcast