Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

If I remember correctly this always happens with SQL 2005. I don't thing that a newer service pack will fix this. Though you should upgrade to the latest service pack if possible.

share|improve this answer
    
Let me try to update to SP4 and I will let you know. Thank you for the help so far. –  user1161308 Jan 24 '12 at 18:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.