Re: SQL Service saturating CPU

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Thu, 11 Nov 2004 08:28:03 -0600

"topokin" <topokin@discussions.microsoft.com> wrote in message
news:F992C19E-CF33-47A9-BFDB-0FCCB6453FA4@microsoft.com...
>I am for a while experiencing SQL Service "sqlservr.exe" saturating the CPU
> on our Server. The Service uses an average of 99% of CPU time, even when
> no
> user is connected to any of the configured databases. I once disconnected
> the NIC and rebooted the system, however the level still stay within 94 -
> 99
> percen.
>
> The only thing I can see running while checking through "Current Activity
> >>
> Process Info", is "dbcc inputbuffer" on Master with "SELECT INTO" command,
> yet "sqlservr.exe" still on about 99%.
>
> What could be going wrong and how can I resolve this.
>
> Regards,
> topokin

Try running profiler for a while and see what is going on in the system.
The SELECT INTO command that you are talking about was caused when you did
the current activity command.

Are indexes being rebuilt? Are statistics being updated?

Does it always run at 99% or just for short periods of time?

Turn on Performance Monitor and track the CPU usage for SQL Server for a few
hours and see if that tells you anything.

Rick Sawtell
MCT, MCSD, MCDBA

Relevant Pages

  • Re: Convert SAP Oracle Database to IBM DB2 Database??
    ... DB server CU that is beibg measured. ... WTH has that got to do with db2 compression? ... (I hope you take no issue with CPU time> Wall clock time) ... "The values were taken from transaction ST06"? ...
    (comp.databases.oracle.server)
  • X.org 7.3 sure is a mess...
    ... Firefox hangs the server, using lots of CPU time, and the only way to get ... All that mucking around to get through the upgrade, ...
    (freebsd-questions)
  • Re: Server 2003 slow to a crawl
    ... MCSA Windows 2003 server ... CPU time is 1-2%, Network activity is negligible, ... Windows on the server take around 5 ...
    (microsoft.public.windows.server.general)
  • Re: NEW RESULTS ...
    ... Now I've found out that "explorer.exe" is taking up 20% of overall CPU time ... on the Server, for no particular reason. ... Nexus DB MM with automatic encryption and compression, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: SamplingProfiler 1.3.5 posted, with experimental threading support
    ... Thread slices vary across O/S (most between server and OS, server having longer time slices), and don't get shorter than 6 ms unless the thread gets stuck on something or relinquishes its CPU time. ... You can have faster timers by handling them in a thread, but only when your thread has CPU time (but then profiled application threads won't progress, so it's useful only for profiling single-threaded applications ... And come to think of it: Would it be a good idea to allow start/stop profiling using a global hotkey? ...
    (borland.public.delphi.language.basm)