EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters hogs CPU although no alerts enabled - by SQLKnitter

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 536354 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 2/25/2010 3:55:33 AM
Access Restriction Public


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.
Sign in to post a comment.
Posted by Daniel Adeniji on 9/8/2015 at 5:03 PM
Can someone please let us if there is an actual fix for this that we can try against an MS SQL Server v2005 instance.
Posted by SQLKnitter on 6/8/2010 at 4:23 AM
Hello: yes, I can apply this to one of my SQL 2008 boxes.

Many thanks

Posted by Microsoft 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]
SQL Server
Posted by Microsoft on 2/26/2010 at 8:54 AM
Holly -

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.


Amy Lewis