Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 536354
Opened: 2/25/2010 3:55:33 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.