skip to main content
Using the driver : Using failover : Always On Availability Groups
  

Try DataDirect Drivers Now

Always On Availability Groups

The driver supports Always On Availability Groups. Introduced in SQL Server 2012, Always On Availability Groups is a replica-database environment that provides a high-level of data availability, protection, and recovery. Follow the proceeding guidelines to use the driver with Always On Availability Groups.
*You must specify the virtual network name (VNN) of the availability group listener with the ServerName property to connect to an Always On Availability group.
*Set the ApplicationIntent property to ReadOnly. By setting applicationIntent to ReadOnly and querying read-only database replicas when possible, you can improve efficiency by reducing the workload on read-write nodes.
*Set the MultiSubnetFailover property to true. This allows the driver to attempt parallel connections to all the IP addresses associated with an Availability Group. This offers improved response time over traditional failover, which attempts connections to alternate servers one at a time.