Instead of relying on Replication Monitor to assess subscriber health and identify pending commands, we can query the msrepl_commands table in the distribution database directly. This approach allows us to analyze undistributed commands by various attributes, providing a deeper understanding of the throughput across the entire replication environment. Furthermore, we can port these metrics into… Continue reading

Part 2 of the Replication Monitoring Series We can answer the question, ‘Is the replication environment healthy?’ with a single monitoring metric: the size of the distribution database. Because the distribution database functions largely as a queue, it should remain relatively small. The Distributor holds replication commands from the Publisher only until all Subscribers have… Continue reading