As per my know sp_server_diagnostics is supposed to run every 1/3rd of the HealthCheckTimeout Value. Currently in the WSFC Manager, HealthCheckTimeout is set to 30 seconds. So it should run in every 10 seconds. But when I am checking in SQLDIAG Logs (SERVERNAME_INSTANCENAME_SQLDIAG_0_TIMESTAMP.XEL), I can see the output is coming in every 1 min 40 seconds.

Does it mean, it takes 1 min 40 second to run entire proc once? And if yes, then it should have initiated failover?

Am I missing anything? I just started learning AlwaysOn internals.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.