SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL Server 2008 R2 spamming event log
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tfountain
Constraint Violating Yak Guru

USA
491 Posts

Posted - 10/10/2012 :  13:39:46  Show Profile  Reply with Quote
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

USA
15655 Posts

Posted - 10/10/2012 :  13:46:34  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

tfountain
Constraint Violating Yak Guru

USA
491 Posts

Posted - 10/11/2012 :  11:16:25  Show Profile  Reply with Quote
Rob, thanks for the link. I might just do the same thing as I agree with the health check for SQL Agent. Heck, I'm fine with 5 minutes.
Go to Top of Page

ciminelj
Starting Member

USA
1 Posts

Posted - 02/20/2014 :  11:12:52  Show Profile  Reply with Quote
How/where do you change the polling rate for Is Alive?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000