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.


2
0
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

Description

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 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
Holly,
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?
Thanks
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.

Thanks,

Amy Lewis