Re: SQL Server Service jumps to 100% of CPU time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick Sawtell (quickening_at_msn.com)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 12:57:14 -0600

"James" <jtyree@nospam.nospam> wrote in message
news:eC7woo0xEHA.1300@TK2MSFTNGP14.phx.gbl...
> Our customer is running our custom application that uses MS SQL Server
> 2000. Periodically, maybe once a week or so, the processor usage
> percentage climbs to the point where he can't even log into the server at
> the console and receives a message telling him that the server is too
> busy. If he happens to be logged in when this happens, he can stop and
> restart the service and everything is fine, however, when users start to
> log back into the application, the usage begins to climb again.
>
> Our application is a more or less a fancy cash register with some
> reporting. Customer states that they're not running any reports when this
> happens and our app isn't database intensive by any means.
>
> I'd appreciate any suggestions on where/how to begin researching what is
> causing the jump in processor usage.
>
> Thank you
>
> James
>

Run the SQL Profiler on it and see what happens.

My initial guess is that some part of your app is getting caught in a loop.

My second guess would be to check the maintenance plans and see whether or
not index rebuilds are taking place and so forth.

Rick Sawtell
MCT, MCSD, MCDBA

Relevant Pages

  • Re: Efficient coordinated queries??
    ... :-) We are distributing processing over a large server farm -- bringing it back onto the SQL server would probably kill our performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ... A large chunk of it can be brought in with a single query and each row represents an item to process. ... For a hypothetical example consider a customer order database where we need to process through all customers and can bring in a row of customer data as our main query but there are 0..n1 rows of customer order data, 0..n2 rows of customer feedback information, 0..n3 rows of customer discounts available, etc. ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Server Service jumps to 100% of CPU time
    ... Our customer is running our custom application that uses MS SQL Server 2000. ... Periodically, maybe once a week or so, the processor usage percentage climbs ...
    (microsoft.public.sqlserver.server)
  • Re: Subscription cant be created
    ... Sql Server is installed on a 64 bit Windows 2008 Server. ... The strange thing is that this is happening only at one 64 bit Windows 2008 Server. ... Reinstalling SQL Server isn't an option, because it is a production Server of a customer. ...
    (microsoft.public.sqlserver.replication)
  • Moving Databases to a remote server
    ... I have a customer that's currently running WSS and SQL on the same server. ... They now purchased a new machine strictly for SQL Server and want to move ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Client port for SQL
    ... That would probably work all right for the one customer, ... customers use the same server on port 1433. ... Can both the web site and SQL Server use the same port? ...
    (microsoft.public.dotnet.languages.vb)