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
Hellow!
One of my production server is executing sp_sqlagent_get_perf_counters procedrue every 60 seconds.
Why?
How to Stop it?
TIA,
Paul
Hi,
we are using MS SQL 7.0 and whenever the sp EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters runs it causes huge io reads and at the same time CPU Util of Database server goes to 100% though the CPU util of this proc is 0 or near zero..
I am not sure though that this is the problem ...but to check whether this is the problem i need to disable this...
This runs every 20 seconds and i know we can disable this is sQL 2000
by changing registry settings ...
Is there a similar way for SQL 7.0 to disable this sp