Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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

migrated from stackoverflow.com Jan 20 '12 at 21:17

This question came from our site for professional and enthusiast programmers.

    
Need more information. Are you saying these queries are coming from profiler, or that you notice them in profiler? You said "...profiler is running..." so just want to clarify. Talk about the other columns in your trace, such as hostname, program name, etc. Maybe someone has perfmon or some other monitoring tool up on their workstation on an aggressive polling interval and went home for the day. –  Aaron Bertrand Jan 20 '12 at 22:54
    
That all said, you shouldn't still be on SP2, it is no longer supported. You should have moved to at least SP3 but SP4 is your better bet. Once you have tested that it doesn't break your app, etc., of course. –  Aaron Bertrand Jan 20 '12 at 22:55
add comment

1 Answer

Does it matter, unless it is sucking resources? As I understand it (from some searches), it will run anyway.

There is an MS Connect item for SQL Server 2008 for CPU usage, but it looks unresolved

share|improve this answer
add comment

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.