SQL Server 2016 – Database Scoped Configuration Parameters and Always On Availability Group failovers.
Posted: May 10, 2017 Filed under: Microsoft SQL Server, Microsoft SQL Server 2016, Uncategorized | Tags: Microsoft, Microsoft SQL Server, Microsoft SQL Server 2016 Leave a commentIn SQL Server 2016 we have database scoped parameters.
With an AlwaysOn Availability Groups we can have different database scoped parameter values on the primary compare to the secondaries.
How does this work with an Always On Availability Group failover ?
http://smooth1.co.uk/sqlserver2016/AA_AG_DSP.html
Advertisements