Alwayson - 流量控制和同步复制 [英] Alwayson - Flow Control and Synchronous replica

问题描述

如果我有同步模式的主副本和辅助副本进入流量控制，请告诉我由于资源过量，将对正在进行的交易产生什么影响..他们会等待或继续处理，send_queue会在主副本上构建
？

Please let me know if I have Primary and secondary replica in sync mode and Secondary went into Flow control because of overusage of resources, what impact will be on going transactions.. will they wait OR continue processing and send_queue will be built up on Primary replica?

谢谢

推荐答案

由于资源的过度使用，我没有听说流量控制中的数据库。在辅助设备上发生的任何事情都不会妨碍主要的可用性和连接性。只有当次要
断开连接时，您需要看到的事务日志文件呈指数级增长

I have not heard database going in flow control because of over usage of resource. Anything happening on secondary will not hamper primary availability and connectivity. Only thing you need to see is transaction log file growing exponentially if secondary gets disconnected

这篇关于Alwayson - 流量控制和同步复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！