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.
- 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?