msdb.dbo.sp_sqlagent_get_perf_counters Help??????

ArrayJeansonWu

Hello, I was running SQL Profiler and
noticed stored procedure
SQL:Batchcomplete N\'Testing Connection
EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters
was running for every 20 seconds,which pull down performance.

Can any one help me what causes this one and how to get rid of this?

luyan126115

msdb..sp_sqlagent_get_perf_counters is used to fire the the sqlagent alerts.

Whenever there is a lert set,this procedure is executed in background to determine
the threshold limits, be it an alert for any performance condition .

You mention that it runs frequently,but by default its 20 seconds.Theres a registry
key to change the interval

HKLM\\SOFTWARE\\Microsoft\\MSSQLServer\\SQLServerAgent REG_DWORD
PerformanceSamplingInterval

JeansonWu

Thanks in advance !
But it doesn\'t work even if i modified the registry value.
BTW,I have the other servers ,and i monitor them ,and i found they have the same set,but only this serve is running this procedure 20 minutes once.

JeansonWu

Thanks .it\'s ok!and i have tried to delete all the alerts ,it also can do this issue
But i think that\'s not the root cause!
------------\"BTW,I have the other servers ,and i monitor them ,and i found they have the same set,but only this serve is running this procedure 20 minutes once.\"