EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters hogs CPU although no alerts enabled

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

Closed

as Fixed

Type:	Bug
ID:	536354
Opened:	2/25/2010 3:55:33 AM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

SQL Server 2008 SP1

SQL Engine

Windows Server 2008

English

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!

X64

0 attachments

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