sp_sqlagent_get_perf_counters?

[Guest_imported]

We recently moved a SQL database from one SQL server to another. We backed up the database and restored on the new server. All went well, but the applications that access the databases are taking 10 times longer to retrieve the data. I have been running the SQL profiler to see what is happening, and I notice the following:

Event Class Text Start Time
+SQL:BatchStarting SELECT N'Testing Connection...' 12:05:36.750
+SQL:BatchStarting EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

This occurrs every 20 seconds. Any ideas???

 

[tlbroadbent]

That is just part of the normal SQL Server statistics gathering process. That is the way SQLAgent determines if alert thresholds have been reached. It hasn't seemed to cause us any problems. Are you just curious or are you encountering problems?

You can change the sampling interval in the registry.

Add a REG_DWORD value named PerformanceSamplingInterval to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\DEV\SQLServerAgent

I believe that if you set the value to zero you will disable sampling. The default sampling interval is 20 seconds. Set it to a higher value to reduce sampling frequency. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual.

 

[RickCole]

Have you checked all the configuartion options are the same on the new server as they were on the old one??

Rick

 

[Guest_imported]

Will try that suggestion. The reason I wanted to know is because we are experiencing a big slowdown with regards to the applications that access this database. If I don't see an improvement I might change it back.

Thanks TLBroadbent, I'll keep you posted on what happens!

tvdinner