I think I have discovered what is causing a performance issue for our end users. This issue is very sporadic and typically doesn't last longer than a minute or so. Therefore, it has been hard to figure out what was causing this issue. After performing a number of SQL Profile traces I have noticed that the following command is running every time they are having an issue:
msdb.dbo.sp_sqlagent_get_perf_counters SQLAgent - Alert
After doing some reading I know that this is related to Alerts in SQLServer but we don't have any alerts set up. After looking at some forums they suggest setting a key in the registry under SQLServer Agent to 0. The key is called PerformanceSamplingInterval and is supposedly under: HKLM\Software\Microsoft\Microsoft SQLServer\YourInstance\SQLServerAgent.
Well, I cannot find this registry setting in SQLServer 7. It must be in SQL2000. Does anyone out there know how I can turn this procedure off in SQLServer 7? I haven't been able to find anything.
Regards,
Bessebo
msdb.dbo.sp_sqlagent_get_perf_counters SQLAgent - Alert
After doing some reading I know that this is related to Alerts in SQLServer but we don't have any alerts set up. After looking at some forums they suggest setting a key in the registry under SQLServer Agent to 0. The key is called PerformanceSamplingInterval and is supposedly under: HKLM\Software\Microsoft\Microsoft SQLServer\YourInstance\SQLServerAgent.
Well, I cannot find this registry setting in SQLServer 7. It must be in SQL2000. Does anyone out there know how I can turn this procedure off in SQLServer 7? I haven't been able to find anything.
Regards,
Bessebo