|
Home > Archive > MS SQL Server > March 2006 > Idle Sql Agent consumes CPU
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Idle Sql Agent consumes CPU
|
|
| Randolph Neall 2006-03-15, 3:23 am |
| The performance monitor on our Win 2003 server often shows CPU at 25%, due
entirely to Sql Server Agent at a time when the agent shows no jobs running.
We stop and restart the agent, and CPU consumption drops to zero. A day or
two later and we're back to 25% again because of the agent. We're running
Sql Server 2000.
What is the problem?
Thanks,
Randy Neall
| |
| Sue Hoegemeier 2006-03-15, 3:23 am |
| Did you also watch with Profiler to see what's going on?
If you aren't using alerts, you could try deleting the demo
alerts that are installed by default. You can script out the
alerts first and then drop them.
-Sue
On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
< randolphneall@veraci
tycomputing.com> wrote:
>The performance monitor on our Win 2003 server often shows CPU at 25%, due
>entirely to Sql Server Agent at a time when the agent shows no jobs running.
>We stop and restart the agent, and CPU consumption drops to zero. A day or
>two later and we're back to 25% again because of the agent. We're running
>Sql Server 2000.
>
>What is the problem?
>
>Thanks,
>
>Randy Neall
>
>
| |
| Randolph Neall 2006-03-15, 8:23 pm |
| Thank you, Sue. We'll try to follow your advice.
Randy
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:8f9f12dc24sqedo
dsd954e24flcs22tfat@
4ax.com...
> Did you also watch with Profiler to see what's going on?
> If you aren't using alerts, you could try deleting the demo
> alerts that are installed by default. You can script out the
> alerts first and then drop them.
>
> -Sue
>
> On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
> < randolphneall@veraci
tycomputing.com> wrote:
>
due[color=darkred]
running.[color=darkred]
or[color=darkred]
>
|
|
|
|
|