We help IT Professionals succeed at work.

SQL 2016 scaleble read operation by AOG

marrowyung asked

I am setting up SQL 2016 AOG on Windows 2016 server and testing it how flexible it is, I know from SQL 2014, the read operation ca can be load balanced by AOG, how is it done?

any enhancement about this on SQL 2016?
Watch Question

EE Topic Advisor
Most Valuable Expert 2014
Awarded 2013
What's new in SQL Server 2016
In-memory OLTP:: Has column store index enhancements for sorting and Always On Availability Group support.
SQL Server 2016 Integration Services (SSIS):: Support for Always On Availability Groups

SQL Server 2016 AlwaysOn Availability Group Enhancements: Basic Availability Group on Standard Edition
Basic availability groups provide the capability to use AlwaysOn availability groups with SQL Server Standard Edition servers, with the same limitations that database mirroring imposes today.

SQL Server 2016 AlwaysOn Availability Group Enhancements: Multiple Automatic Failover Targets
SQL Server 2104 and SQL Server 2012 can have two synchronous secondary replicas. One synchronous secondary replica can serve the role as automatic failover partner with the primary replica.

In SQL Server 2016 both synchronous secondary replicas can be configured as automatic failover partners with the primary replica.
marrowyungSenior Technical architecture (Data)



I am referring to the read operation can be load balanced by AOG, did you try it before ? how can we verify it if it is really load balanced ?
PberSolutions Architect

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: PortletPaul (https:#a42391893)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer