SQL Server Performance

what is msdb.dbo.sp_sqlagent_get_perf_counters which eats my CPU ???

Discussion in 'Performance Tuning for DBAs' started by suniljk7, Aug 8, 2007.

  1. suniljk7 New Member

    Dear All,

    When i run profiler i could see lots of entry like :
    EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters
    which takes lots of CPU and high duration to finish (more than 3000 ms)
    i did lots of google search but couldn't find much information,
    can u please guide me with this and how to aviod this which takes more time and cpu..

    this is very urgent.
  2. Adriaan New Member

    Please do not double-post.
    The regulars around here are looking at the 'Active topics' so your question will catch someone's attention pretty soon.
    Meanwhile, you'll have to wait for someone else's more knowledgeable reply.[;)]

Share This Page