Re: what is msdb.dbo.sp_sqlagent_get_perf_counters
- Dear all,
I checked and find all the 9 demo alerts where running on the production db. but why is it talking so much time to run (its a system procedure which should finish fast?? ) how can i track this.. why is it talking so much time to finish and eating all the CPU? please help me to find out the issue behind this..
----- Original Message ----
From: kanth240 <kanth240@...>
To: sunil john <suniljk7@...>
Sent: Friday, August 10, 2007 9:42:32 AM
Subject: Re: what is msdb.dbo.sp_sqlagent_get_perf_counters
The entries are being raised by SQL Agent Alert engine. Disable all
the alerts defined in your SQL box(not a good option in Production
Env) and such events may take less time but they do not cease as long
as your SQL Agent is running.
--- In firstname.lastname@example.org, sunil john <suniljk7@...> wrote:
> 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
> i did lots of Google search but couldn't find much information,
> can u please guide me with this and how to avoid this which takes
more time and cpu..
> this is very urgent.
> Best Regards
> Sunil John
> Send instant messages to your online friends
> [Non-text portions of this message have been removed]
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]