How It Works: SQL Server AlwaysOn Lease Timeout

Published Jan 15 2019 02:41 PM 221 Views
Microsoft
First published on MSDN on Nov 15, 2013

The LeaseTimeout controls the lease mechanism and when the lease expires there is a very high probability of a system wide event taking place.   Let me explain more and why I make this statement.


Based in recent cases I needed to extend and clarify this post.


http://blogs.msdn.com/b/psssql/archive/2012/09/07/how-it-works-sql-server-alwayson-lease-timeou...


Bob Dorr - Principal SQL Server Escalation Engineer

%3CLINGO-SUB%20id%3D%22lingo-sub-317270%22%20slang%3D%22en-US%22%3EHow%20It%20Works%3A%20SQL%20Server%20AlwaysOn%20Lease%20Timeout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-317270%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Nov%2015%2C%202013%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EThe%20%3CSTRONG%3E%20LeaseTimeout%20%3C%2FSTRONG%3E%20controls%20the%20lease%20mechanism%20and%20when%20the%20lease%20expires%20there%20is%20a%20very%20high%20probability%20of%20a%20system%20wide%20event%20taking%20place.%26nbsp%3B%26nbsp%3B%20Let%20me%20explain%20more%20and%20why%20I%20make%20this%20statement.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EBased%20in%20recent%20cases%20I%20needed%20to%20extend%20and%20clarify%20this%20post.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fpsssql%2Farchive%2F2012%2F09%2F07%2Fhow-it-works-sql-server-alwayson-lease-timeout.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Fpsssql%2Farchive%2F2012%2F09%2F07%2Fhow-it-works-sql-server-alwayson-lease-timeout.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EBob%20Dorr%20-%20Principal%20SQL%20Server%20Escalation%20Engineer%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-317270%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Nov%2015%2C%202013%20The%20LeaseTimeout%20controls%20the%20lease%20mechanism%20and%20when%20the%20lease%20expires%20there%20is%20a%20very%20high%20probability%20of%20a%20system%20wide%20event%20taking%20place.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-317270%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHigh%20Availability%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 02:41 PM
Updated by: