Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Blum
  Where is Ken Blum?
 Illinois - United States
 Ken Blum
 To: John Discallar
  Where is John Discallar?
 John Discallar
Thread ID: 50895 Message ID: 50979 # Views: 1 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Tuesday, September 07, 2004 4:21:55 PM         

> Hi FoxGurus,
> At some point our SQL SERVER became very slow and disables the CLIENTS to connection and perform
> successful transactions, our programs became very slow and somtime hangs ,
> When I loaded the PROFILER i saw that the SERVER is always executing the SP_SQLAGENT_GET_PERF_COUNTERS
> stored procedure, what is this? is this a virus? , i tried scanning but found no infection.
> What should I do to make our server more faster , can i just delete the said procedure?
> Regards,
> Foxpro Child
> On Error Goto Hell

"sp" SPROCS are system procedures and should not/cannot be deleted. A good forum for SQL Server problems is www.sqlteam.com



SP_SQLAGENT_GET_PERF_COUNTERS Posted by John Discallar @ 9/7/2004 3:10:56 AM
RE: SP_SQLAGENT_GET_PERF_COUNTERS Posted by Paul Brown @ 9/7/2004 9:59:49 AM
RE: SP_SQLAGENT_GET_PERF_COUNTERS Posted by Ken Blum @ 9/7/2004 4:21:55 PM