Search

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

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)
1
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)
Product Language
English

Version

SQL Server 2008 SP1

Category

SQL Engine

Operating System

Windows Server 2008
Operating System Language
English
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
Actual Results
Process doesn't seem to want to stop
Expected Results
Process should stop!

Platform

X64
File Attachments
0 attachments
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.