A little background info: We are running SQL Server 2005 SP2 on a server with Microsoft Windows Server 2003 SP2. When I run profiler I notice that EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters is running every 20 seconds.
Here is what the profiler is running every 20 seconds: SELECT N'Testing Connection...' go EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters go
What I have done so far: I have deleted all the demo alerts on the system.
Possible answers: I was wondering if a service pack 3 or 4 on 2005 might fix this issue? or is there something I can set in the registry or in sql itself? or is there a patch for Windows Server 2003 that might help?