Re: High CPU Usage

From: Zach Wells (zwells_at_remove_ain1.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 10:27:49 -0500

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: virus scanning SQL 2000 databases
    ... Consideration for a Virus Scanner on a Computer That Is Running ... SQL Server MVP ... > I use McAfee antivirus and veritas backup exec for tape backups. ... > Are there any other directories or files I should exclude from virus scan ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Infected by SQL Slammer Virus
    ... why do you believe that you even have a virus on ... let me specifically address the SQL Slammer worm. ... SQL Server, if SQL Server is responsive enough to be stopped - the worm uses ... getting infected again is to install SQL Server SP3. ...
    (microsoft.public.sqlserver.security)
  • Re: Virus scannnig document before saving to database
    ... Kevin, thanks for your replay but that means all my operations would not be ... sql server, i.e i can not wrap it all in one sql server transaction. ... sql server 2000 database and before these are saved to the ... have invoked the local APIs of the anti virus running on the server but in ...
    (microsoft.public.dotnet.general)
  • Re: High CPU Usage
    ... query raises over 70% CPU usage? ... >> Virus Scan installed on it. ... >> This SQL is used as a reporting SQL Server and the ... >You need to determine what is causing the problem first, ...
    (microsoft.public.sqlserver.programming)
  • High CPU Usage
    ... I have an SQL Server 2000 SP3a running on Quad Proc (3.2 ... GHz), 4 GB RAM. ... Virus Scan installed on it. ... What should I look into to resolve this kind of situation. ...
    (microsoft.public.sqlserver.programming)