The parameter Logging.DurabilityLevel can take one of the following values:
▪ 1 (relaxed durability) If you want to set a maximum delay time before the server writes data to the transaction log, use the Logging.RelaxedMaxDelay parameter, see Logging section.
▪ 2 (adaptive durability)
▪ 3 (strict durability)
Adaptive durability
Adaptive durability is meant for HotStandby operation. If the value of the Logging.DurabilityLevel parameter is set to 2 (adaptive), the actual durability level is determined by the following factors:
▪ If HotStandby is not enabled, the server uses strict durability.
▪ If HotStandby is enabled then:
– if the server is a primary server in PRIMARY ACTIVE state, the server uses relaxed durability.
– in all other cases, the server uses strict durability.