标题: msdb.dbo.sp_sqlagent_get_perf_counters Help?????? [打印本页] 作者: ArrayJeansonWu 时间: 2005-07-12 08:29 标题: msdb.dbo.sp_sqlagent_get_perf_counters Help?????? 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 时间: 2005-07-12 09:26
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 时间: 2005-07-12 10:53
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 时间: 2005-07-12 12:46
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.\"