Availability Group Latency Reports

Sourabh Agarwal points out some new reports in Management Studio 17.4:

The Latency data collection functionality and the associated reports allows a database administrator to quickly discern the bottleneck in the log transport flow between the Primary and the Secondary replicas of an Availability Group. This feature does NOT answer the question “Is there latency in the Availability Group deployment?” but rather provides a way to understand why there is latency in the Availability Group Deployment. This functionality provides a way to narrow down the potential cause of latency in an Availability Group deployment.

There are some things that this report doesn’t capture, but it does give us a bit more insight.

Related Posts

Hidden Modals and SSIS

Jana Sattainathan knows how to make hidden modals rise to the surface in SSMS: I am not sure if run into this but I do often enough on my SSMS 17.9.1 version – suddenly, the SSMS window will not register any mouse-clicks although it will seemingly look fine. The reason is because there is a Modal […]

Read More

Execution Plan Properties

Erik Darling reminds you to check out the properties of execution plan elements: I read a lot of posts about query plans, and I rarely see people bring up the properties tab. And I get it. The F4 button is right next to the F5 button. If you hit the wrong one, you might ruin […]

Read More

Categories

December 2017
MTWTFSS
« Nov Jan »
 123
45678910
11121314151617
18192021222324
25262728293031