测量可用性组同步滞后 - 澄清 [英] Measuring Availability Group synchronization lag - Clarifications
问题描述
我可以在下面获得一些帮助
Can I get some help on below
由于我已经开始并且了解了包含BCP的复制品之间的可用性组测量同步滞后,我想了解和学习这个查询或仪表板显示包括FileStream同步滞后的值?
As I have started and learning about the Measuring of Availability Group synchronization lag between replicas inclusive of BCP , I want to understand and learn that does this query or dashboard show the values including FileStream synchronization lag ?
我的数据库启用了FileStream。 我正在使用SQL Server 2014 SP2 AOAG。
My Databases are with FileStream enabled . I am using SQL Server 2014 SP2 AOAG.
请帮助我理解上述内容,并建议我使用良好的链接或查询来衡量副本之间的同步伙伴。
Please help me understand the above point and kindly advise me with good link or query to measure the Sync lad between replicas.
最好的问候,SQLBoy
Best Regards,SQLBoy
推荐答案
它查看以下DMV。
It looks at the following DMV.
sys.dm_hadr_database_replica_states
sys.dm_hadr_database_replica_states
我通常会查看redo_queue和secondary_lag_seconds。
I normally look at the redo_queue and secondary_lag_seconds.
这篇关于测量可用性组同步滞后 - 澄清的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!