SQL Server 2008 R2 spamming event log

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

SQL Server 2008 R2 spamming event log

Author

Topic

tfountain
Constraint Violating Yak Guru

491 Posts

Posted - 2012-10-10 : 13:39:46

We are getting this in our event log several times every second:

[sqagtres] CheckServiceAlive: returning TRUE (success)

I've done some Googling and it seems to be a bug introduced by SQL Server 2008 R2 and fixed in SQL Server 2012. But that's the extent of what I'm finding. Any chance someone here has experience with this and how to prevent it from occuring in SQL Server 2008 R2?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-10-10 : 13:46:34

From here:

http://connect.microsoft.com/SQLServer/feedback/details/737820/sql-2012-cluster-checkservicealive-spams-application-event-log

One suggestion was to reduce the polling interval on SQL Agent in the cluster resource Advanced Properties. Other than that there doesn't seem to be a fix yet.