SQLHokanson

Keeping the lights on: Managing large database environments

PowerShell

January 31, 2026

Tracking Replication Errors

Continuing our Replication Monitoring series, this fourth installment explores how to surface a couple metrics that highlight ongoing replication errors. Our goal is simple: provide immediate visibility into where failures are occurring so that DBAs can intervene at the correct point in the pipeline to begin their investigation. While we are focusing specifically on Transactional… Continue reading

SQL Replication

Distribution Agents, distribution database, Grafana, InfluxDB, Log Reader Agents, PowerShell
December 31, 2025

Tracking the Replication Log Reader Latency

Part 1 of the Replication Monitoring Series There is an existing MSSQLTips.com blog post that shares how to identify the Replication Log Reader latency via Replication Monitor and by querying the Distributor’s distribution system tables. In this blog post, I will share another approach to identify the latency metric by utilizing the Publisher’s log file.… Continue reading

SQL Replication

DBCC OPENTRAN, Distributor, fn_dblog(), Latency, Log Reader, PowerShell

About Me

I’m Jeff Hokanson, a 20-year database professional residing in Plymouth, MA, with my family. My passion is tackling the challenges of high-volume transactional databases. I focus on increasing our understanding of the ‘under the hood’ operations. This enhanced transparency is critical for early detection, allowing us to address performance constraints and avoid major slowdowns.

PowerShell

Tracking Replication Errors

Tracking the Replication Log Reader Latency