Sp_sqlagent_get_perf_counters

Jun 20, 2001

Hellow!
One of my production server is executing sp_sqlagent_get_perf_counters procedrue every 60 seconds.
Why?
How to Stop it?

TIA,
Paul

View 4 Replies


ADVERTISEMENT

Problem With Sp_sqlagent_get_perf_counters

Jan 24, 2007

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

View 5 Replies View Related

SQL Server 7.0 How To Disable Msdb.dbo.sp_sqlagent_get_perf_counters

Jan 25, 2004

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

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved