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 me
some ideas on how to fix this?
Thanks so much,
Jenna
Open 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