Azure SQL load balance consideration
In this article I explained about the Azure SQL Load balance with read only replicas What is read only replicas? The replica of the primary database which allows read only access. Secondary replica can be in either synchronous-commit availability mode, or asynchronous-commit availability mode. Availability of read only replicas Availability of read only replicas are based on the tiers. Read Scale-Out is enabled by default on Premium, Business Critical and Hyper scale service tiers. Read Scale-Out cannot be enabled in Basic, Standard, or General Purpose service tiers. Read Scale-Out is automatically disabled on Hyper scale databases configured with 0 replicas. You can disable and re-enable Read Scale-Out on single databases and elastic pool databases in Premium or Business Critical service tiers. Consuming read only replicas We have option to configure the application indent as be...