April 2017 Entries

SQL server AlwaysOn Availability Group data latency issue on secondary replicas and synchronous state monitoring

This article explains how data synchronization works on SQL Server AlwaysOn Availability Group and some details about how to use sys.dm_hadr_database_replic... table to check replica states.I borrowed this daligram from this article which explains data synchronization process on SQL Server AlwaysOn Availability group. The article has full details about the process. Things are worthing noting here are step 5 and 6.When a transaction log is received by a secondary replica, it will be cached and ......

Posted On Sunday, April 30, 2017 9:58 AM | Comments (6)

Copyright © Changhong Fu

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski