Results 1 to 6 of 6
  1. #1
    Join Date
    May 2005
    Posts
    22

    Unanswered: Problem with sp_sqlagent_get_perf_counters

    I have problem with my production server, it is 4 CPUs and they utilized 100%. And i found this stored procedure EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters taking highest CPU time. And i already turned off all the alerts. And i even killed this stored procedure, but still it is executed by some process, i don't know how it is executing.
    Kiran

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Shut down the SQLAgent service, and these calls will go away. I am going to guess your 100% CPU problem will remain, however.

  3. #3
    Join Date
    May 2005
    Posts
    22
    I restarted sql agent, but again it is getting fired by some process.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If you restarted it, of course, SQL Agent will keep sending these queries to the server. What happens when you leave it shut down?

  5. #5
    Join Date
    May 2005
    Posts
    22
    I have shutdown the sqlAgent in my server, msdb.dbo.sp_sqlagent_get_perf_counters process was killed by system it self. and now the CPU utilization has reduced from 75% to 50%.
    But this solution doesn't work for me because, i have some backup jobs running, so i have to start sqlAgent again. Can you suggest me any other solution how to stop running msdb.dbo.sp_sqlagent_get_perf_counters process without stopping sqlAgent.

  6. #6
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194
    Hi, open the code of this sp.
    it's loading all enabled alerts int a temp table and then joining it with sysperfinfo table.

    as you said the alerts are off; make sure(select * from msdb.dbo.sysalerts where enabled=1) returns nothing.

    run this sp manually and check the execution plan, and check if the cpu spikes when u run it manually.
    Cheers!





    !Direction is More Important than Speed!

    http://talatnauman.blogspot.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •