SQL Server 2017: Read-Scale Availability Group
Till SQL Server 2016, it was required to create Windows Server Failover Clustering (WSFC) to set up Availability groups irrespective need of project i.e. whether it is required for High Availability or resource conservation on primary server (i.e. to use secondary for read requests).
With SQL Server 2017, we can create availability group without Windows Server Failover Cluster. Of course, it will not act as high availability or disaster recovery set up but it can be used for balancing the read-only load between many servers.
So overhead of maintaining Windows Failover cluster can be avoided if the requirement is just to reduce the read-only load on the primary.
With SQL Server 2017, we can create availability group without Windows Server Failover Cluster. Of course, it will not act as high availability or disaster recovery set up but it can be used for balancing the read-only load between many servers.
So overhead of maintaining Windows Failover cluster can be avoided if the requirement is just to reduce the read-only load on the primary.
How to enable this?
No comments: