[AlwaysOn] T-SQL语法：REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT参数

REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT

在SQL Server 2017中引入。Introduced in SQL Server 2017.

用于设置在主提交事务之前提交所需的最小同步辅助副本数。Used to set a minimum number of synchronous secondary replicas required to commit before the primary commits a transaction. 确保SQL Server事务在事务日志更新到最小辅助副本数之前一直处于等待状态。Guarantees that SQL Server transaction waits until the transaction logs are updated on the minimum number of secondary replicas. 默认值为0，其行为与SQL Server 2016相同。The default is 0 which gives the same behavior as SQL Server 2016. 最小值为0。The minimum value is 0. 最大值是复制副本数减去1。The maximum value is the number of replicas minus 1. 此选项与同步提交模式下的副本相关。This option relates to replicas in synchronous commit mode. 当副本处于同步提交模式时，主副本上的写入操作将等待，直到辅助同步副本上的写入操作提交到副本数据库事务日志。When replicas are in synchronous commit mode, writes on the primary replica wait until writes on the secondary synchronous replicas are committed to the replica database transaction log. 如果承载辅助同步副本的SQL服务器停止响应，则承载主副本的SQL服务器会将该辅助副本标记为未同步并继续。If a SQL Server that hosts a secondary synchronous replica stops responding, the SQL Server that hosts the primary replica marks that secondary replica as NOT SYNCHRONIZED and proceed. 当没有响应的数据库重新联机时，它处于“未同步”状态，并且复制副本标记为不健康，直到主数据库可以使其再次同步。When the unresponsive database comes back online it is in a "not synced" state and the replica marked as unhealthy until the primary can make it synchronous again. 此设置确保主副本在提交每个事务的最小副本数之前一直等待。This setting guarantees that the primary replica waits until the minimum number of replicas have committed each transaction. 如果最小副本数不可用，则在主副本提交失败时提交。If the minimum number of replicas is not available then commits on the primary fail. 对于外部群集类型，当可用性组添加到群集资源时，设置将更改。For cluster type EXTERNAL the setting is changed when the availability group is added to a cluster resource. 有关可用性组配置，请参阅高可用性和数据保护。See High availability and data protection for availability group configurations .

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2653730/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2653730/