![]() With the new SSMS 17.4 release, we are introducing the Availability Group Latency data collection and reporting built into the Availability Group dashboard. This activity can be time consuming and requires extensive knowledge of the Extended Events associated with Always On. To understand the reason for latency, requires capture and analysis of Extended Events and Performance Monitor counters. While the dashboard can be configured to provide information regarding the latency between Primary and Secondary Replicas (can be calculated using the Commit LSN, Sent LSN and harden LSN values), it does not provide insights into the reason for the latency. ![]() This dashboard can be utilized by database administrators to view the current health of an Availability Group and its availability replicas and databases. With SQL Server 2012 we introduced Always On Availability Groups, and the Always On Availability Group Dashboard in SQL Server Management Studio ( SSMS).
0 Comments
Leave a Reply. |