Determines whether the driver attempts parallel connections to the failover IP addresses of an Availability Group during a multi-subnet failover. When Multi-Subnet Failover is enabled, the driver simultaneously attempts to connect to all IP addresses associated with the Availability Group listener when the connection is broken or the listener IP address becomes unavailable. The first IP address to successfully respond to the request is used for the connection. Using parallel-connection attempts offers improved response time over traditional failover, which attempts to connect to alternate servers one at a time.
Valid Values
1 | 0
Behavior
If set to 1 (Enabled), the driver attempts parallel connections to all failover IP addresses in an Availability Group when the connection is broken or the listener IP address is unavailable. The first IP address to successfully respond to the request is used for the connection. This setting is only supported when your environment is configured for Always On Availability Groups.
If set to 0 (Disabled), the driver uses the failover method specified by the Failover Mode connection option when the primary server is unavailable. Use this setting if your environment is not configured for Always On Availability Groups.
Notes
When MultiSubnetFalover is enabled, the virtual network name (VNN) of the availability group listener must be specified by the Host Name connection option.
When MultiSubnetFailover is enabled, the Alternate Servers, Load Balancing, and Failover Preconnect connection options are disabled.
When MultiSubnetFalover is enabled, the virtual network name (VNN) of the availability group listener must be specified by the Host Name connection option.