Re: High CPU Usage

From: Mark (anonymous_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 09:22:43 -0700

One more Question.

Is there anyway I can send an email alert as soon as a
query raises over 70% CPU usage?
>-----Original Message-----
>Mark wrote:
>> I have an SQL Server 2000 SP3a running on Quad Proc
(3.2
>> GHz), 4 GB RAM. This machine has only SQL Server 2k and
>> Virus Scan installed on it.
>>
>> This SQL is used as a reporting SQL Server and the
>> requests are coming via WebFOCUS, ASP etc. CPU is most
of
>> the time in high nineties (96% or so) which makes
queries
>> to take longer to run.
>>
>> What should I look into to resolve this kind of
situation.
>> I have /3GB stich in boot.ini and Max Degree of Parall
set
>> to 4. What else I can do to resolve this sitation.
>>
>> -Mark
>
>You need to determine what is causing the problem first,
not just
>blindly change settings based on uninformed guesses by
strangers in a
>newsgroup hoping one of them works. Have you analyzed
your server? Have
>you ruled out the virus scanning software (I'm not a fan
of that stuff
>sitting on a sql server anyway)? Have you monitored your
connections?
>How many people are hitting your server when it spikes?
Exactly what
>process is taking up that much CPU?
>
>Another helpful bit of information is your hard drive
setup. Are you
>SCSI or IDE? Using RAID? Which raid? 0, 1, 5, 0 + 1?
>
>There are a ton of resources that can help you step
through the analysis
>process and pinpoint *where* the problem is. Once you've
done that, you
>will be in a much better position to fix the problem.
>
>Zach
>.
>

Relevant Pages

  • Re: High CPU Usage
    ... > Virus Scan installed on it. ... > This SQL is used as a reporting SQL Server and the ... What else I can do to resolve this sitation. ... process is taking up that much CPU? ...
    (microsoft.public.sqlserver.programming)
  • Re: CPU at 100%
    ... it trying to download messages. ... Checking for update took several minutes, but while it was checking, CPU ... But again I wasn't able to update Windows. ... Online Anti Virus ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: SQLBulkCopy performance problem
    ... rows to SqlBulkCopy, where is it consuming CPU then? ... >want to insert it into a SQL Server table. ... > system so that I can change parameters of my bulk write operation. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: angry XP home user
    ... svchost or computers running slow. ... That it is a virus or spy ... > high page file usage or stopped the CPU from using 100% ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Full population very slow
    ... performance without stopping & re-locating the FT Catalog. ... MSSearch service's to use one CPU and then use sp_configure to set the ... AT command on the multi-proc server where sql server resides, ... Additionally, as your server has lots of RAM, you can use ...
    (microsoft.public.sqlserver.fulltext)