Skip to content

Commit ff2a028

Browse files
authored
Merge pull request #8904 from MicrosoftDocs/MashaMSFT-patch-3
added table
2 parents 3e993de + 3524129 commit ff2a028

1 file changed

Lines changed: 7 additions & 0 deletions

File tree

docs/database-engine/availability-groups/windows/availability-group-lease-healthcheck-timeout.md

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -147,6 +147,13 @@ ALTER AVAILABILITY GROUP AG1 SET (HEALTH_CHECK_TIMEOUT =60000);
147147
- SameSubnetThreshold \<= CrossSubnetThreshold
148148

149149
- SameSubnetDelay \<= CrossSubnetDelay
150+
151+
| Timeout setting | Purpose | Between | Uses | IsAlive & LooksAlive | Causes | Outcome
152+
| :-------------- | :------ | :------ | :--- | :------------------- | :----- | :------ |
153+
| Lease timeout </br> **Default: 20000** | Prevent splitbrain | Primary to Cluster </br> (HADR) | [Windows event objects](/windows/desktop/Sync/event-objects)| Used in both | OS hang, low virtual memory, generating dump, pegged CPU, WSFC down (loss of quorum) | AG resource offline-online, failover |
154+
| Session timeout </br> **Default: 10000** | Inform of communication issue between Primary and Secondary | Secondary to Primary </br> (HADR) | [TCP Sockets (messages sent via DBM endpoint)](/windows/desktop/WinSock/windows-sockets-start-page-2) | Used in neither | Network communication, </br> Issues on secondary - down, OS hang, resource contention | Secondary - DISCONNECTED |
155+
|HealthCheck timeout </br> **Default: 30000** | Indicate timeout while trying to determine health of the Primary replica | Cluster to Primary </br> (FCI & HADR) | T-SQL [sp_server_diagnostics](../../../relational-databases/system-stored-procedures/sp-server-diagnostics-transact-sql.md) | Used in both | Failure conditions met, OS hang, low virtual memory, working set trim, generating dump, WSFC (loss of quroum), scheduler issues (dead locked schedulers)| AG resouce Offline-oline or Failover, FCI restart/failover |
156+
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp;| &nbsp; | &nbsp; | &nbsp; |
150157

151158
## See Also
152159

0 commit comments

Comments
 (0)