I have implemented Always on Availability Group in asynchronous mode between two servers primary and secondary.
When i tried to check the data latency between the servers in performance monitor using performance counters like MS SQL :availability replica,MS SQL:database replica
and MS SQL:databases
,I'm not able to see any results in the graph.
But the graph is showing results for other performance counters.I've tried to get the data latency using DMV sys.dm_hadr_database_replica_states
.
Can any one tell me what is the issue ?
How can I check the data latency between the two servers in performance monitor using graphs
as shown in the msdn article ?
Best Answer
I used this script in a custom report once.