Wednesday, March 7, 2012

msdb.dbo.sp_sqlagent_get_perf_counters using tons of cpu

msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu usage
on our server. We have hardly anything running in sqlagent. Can you give m
e
some ideas on how to fix this?
Thanks so much,
JennaOpen Enterprise Manager and expand the Management>SQL Server Agent folder
and click on Alerts.You should see 9 alerts whose names all start with Demo.
Select them all and Delete. If you don't use alerts there is no point in
sp_sqlagent_get_perf_counters running. If there are no Alerts defined it
won't run.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenna S." <JennaS@.discussions.microsoft.com> wrote in message
news:8C0811F4-49A9-428C-BFDE-DA060470CAAD@.microsoft.com...
> msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu
> usage
> on our server. We have hardly anything running in sqlagent. Can you give
> me
> some ideas on how to fix this?
> Thanks so much,
> Jenna

No comments:

Post a Comment