Unlike FCI, doesn't AG make use of heartbeat to check for server down?



  • SQL AG in WSFC checks whether server is down via the lease timeout

    Where as SQL FCI checks whether server down via heartbeat

    Does the SQL AG not make use of heartbeat at all?

    Below is a sample log from AG that mentions heartbeat: enter image description here



  • SQL AG in WSFC checks whether server is down via the lease timeout

    Not quite, that's for split brain. FCIs and AGs use the same health check method which is a combination of diagnostic data results and service status.

    Where as SQL FCI checks whether server down via heartbeat

    What heartbeat? There is no heartbeat for SQL.

    Does the SQL AG not make use of heartbeat at all?

    No because none exists.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2