SQL Server Home
EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters hogs CPU although no alerts enabled
2/25/2010 3:55:33 AM
User(s) can reproduce this bug
EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters is running every 20 seconds, despite the fact that no SQL Agent Alerts are enabled. This is eating up CPU.
SQL Server 2008 SP1
Windows Server 2008
Operating System Language
Steps to Reproduce
Ran sp_who2 to identify high CPU processes, ran dbcc inputbuffer(spid) to check what the process was: result = EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters. This runs every 20 seconds.
Disabled all alerts in SQL Agent, and ran sp_who2 again. Process persists
Process doesn't seem to want to stop
Process should stop!
to post a comment.
Please enter a comment.
on 6/8/2010 at 4:23 AM
Hello: yes, I can apply this to one of my SQL 2008 boxes.
on 5/24/2010 at 9:40 AM
We are working on fixing this issue in next release of SQL Server. If we provided a private fix, would you be willing to test this fix on your test system?
Sethu Srinivasan [MSFT]
on 2/26/2010 at 8:54 AM
I looked into this - this AM and it does appear that we call sp_sqlagent_get_perf_counters even if all the alerts are disabled.
We will investigate and see if we can change this for our next release. But until then I don't think this really impacts overall CPU - if you are experiencing CPU issues are you sure this is the problem? Also I confirmed we don't call this if no Alert exist - so if you don't need alerting you could consider removing (instead of disabling) your alerts.
to post a workaround.
Please enter a workaround.
© 2013 Microsoft