SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing

,

Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple secondaries known as ‘replicas’. The secondary replicas allow direct read-only querying or can enforce connections that specify ‘ReadOnly’ as their Application Intent using the new feature called Read-Only routing which can be leveraged to scale […]

Rate

Share

Share

Rate