SQL server runs CPU at 25% all of the time!

Run SQL Profiler

"Sintel Silverblade" wrote in message
news:%23KhJmlQxHHA.3684@TK2MSFTNGP02.phx.gbl...
>I run MS SQL2005. SQL is using 25% of CPU usage when nothing is hitting
>the
> server. I have shut down SQLAgent and monitored all transactions(Zero
> running). The problem is SQL is still pegging the CPU at 25%. How can I
> track down what SQL is doing? If I stop SQL and restart it CPU usage goes
> down to 1% for about 2 hours then goes back up to 25% and stays there.
>
> Any ideas on how to troubleshoot this?
>
> Thanks a ton!
>
>

I have been runing Profiler. Zero activity. That is what is so strange. I
ran Profiler at 2am in the morning zero activity on the server but the SQL
process is still at 25% CPU usage.


"bass_player [SBS-MVP]" wrote in message
news:%23zhTPQTxHHA.3952@TK2MSFTNGP06.phx.gbl...
> Run SQL Profiler
>
> "Sintel Silverblade" wrote in message
> news:%23KhJmlQxHHA.3684@TK2MSFTNGP02.phx.gbl...
> >I run MS SQL2005. SQL is using 25% of CPU usage when nothing is hitting
> >the
> > server. I have shut down SQLAgent and monitored all transactions(Zero
> > running). The problem is SQL is still pegging the CPU at 25%. How can
I
> > track down what SQL is doing? If I stop SQL and restart it CPU usage
goes
> > down to 1% for about 2 hours then goes back up to 25% and stays there.
> >
> > Any ideas on how to troubleshoot this?
> >
> > Thanks a ton!
> >
> >
>
>

I have been runing Profiler. Zero activity. That is what is so strange. I
ran Profiler at 2am in the morning zero activity on the server but the SQL
process is still at 25% CPU usage.


"bass_player [SBS-MVP]" wrote in message
news:%23zhTPQTxHHA.3952@TK2MSFTNGP06.phx.gbl...
> Run SQL Profiler
>
> "Sintel Silverblade" wrote in message
> news:%23KhJmlQxHHA.3684@TK2MSFTNGP02.phx.gbl...
> >I run MS SQL2005. SQL is using 25% of CPU usage when nothing is hitting
> >the
> > server. I have shut down SQLAgent and monitored all transactions(Zero
> > running). The problem is SQL is still pegging the CPU at 25%. How can
I
> > track down what SQL is doing? If I stop SQL and restart it CPU usage
goes
> > down to 1% for about 2 hours then goes back up to 25% and stays there.
> >
> > Any ideas on how to troubleshoot this?
> >
> > Thanks a ton!
> >
> >
>
>

You could run sp_who2 and look at the CPUtime of SPIDs <= 50 and see if there
is anything unusual there....
Cheers,
Paul Ibison

Maybe this: http://support.microsoft.com/kb/931821


--
Andrew J. Kelly SQL MVP

"Sintel Silverblade" wrote in message
news:%23KhJmlQxHHA.3684@TK2MSFTNGP02.phx.gbl...
>I run MS SQL2005. SQL is using 25% of CPU usage when nothing is hitting
>the
> server. I have shut down SQLAgent and monitored all transactions(Zero
> running). The problem is SQL is still pegging the CPU at 25%. How can I
> track down what SQL is doing? If I stop SQL and restart it CPU usage goes
> down to 1% for about 2 hours then goes back up to 25% and stays there.
>
> Any ideas on how to troubleshoot this?
>
> Thanks a ton!
>
>

Or you can run

select * from master..sysprocesses order by cpu desc

Manu Jaidka


"Paul Ibison" wrote:

> You could run sp_who2 and look at the CPUtime of SPIDs <= 50 and see if there
> is anything unusual there....
> Cheers,
> Paul Ibison
>

This looks like the problem. I have SQL2005 Service Pack 1. NON-64 Bit
version.

Here is the process killing my CPU time
Cmd CPU
LAZY WRITER 1510761265

This does not fix perfectly so, I will have to give microsoft a call. Thank
you for everyone's help.

"Andrew J. Kelly" wrote in message
news:ODW4GHWxHHA.4184@TK2MSFTNGP06.phx.gbl...
> Maybe this: http://support.microsoft.com/kb/931821
>
>
> --
> Andrew J. Kelly SQL MVP
>
> "Sintel Silverblade" wrote in message
> news:%23KhJmlQxHHA.3684@TK2MSFTNGP02.phx.gbl...
> >I run MS SQL2005. SQL is using 25% of CPU usage when nothing is hitting
> >the
> > server. I have shut down SQLAgent and monitored all transactions(Zero
> > running). The problem is SQL is still pegging the CPU at 25%. How can
I
> > track down what SQL is doing? If I stop SQL and restart it CPU usage
goes
> > down to 1% for about 2 hours then goes back up to 25% and stays there.
> >
> > Any ideas on how to troubleshoot this?
> >
> > Thanks a ton!
> >
> >
>
>