Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 ?

share|improve this question

migrated from stackoverflow.com Mar 11 at 2:55

This question came from our site for professional and enthusiast programmers.

1 Answer 1

The first graph of that link doesn't show the data latency between two servers. Instead it shows :

  • SQL Server:Database Replica --> Transaction Delay (GREEN COLOR) /
  • SQL Server:Database Replica --> Mirrored Write Transactions/sec (RED COLOR)

And then it says that if you want to get the data latency between two servers, you have to divide both values, but that result is not represented in the graph.

If you use DMV to get these values it wont be exactly as using PERFMON because DMV only shows an accumulative value since the last server start.

I recommend you to get the values of the two counters mentioned before with perfmon and put them in an Excel sheet, use a formula to get the data latency between the two servers and then make a graph.

Hope it's clear. Good luck

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.