Tuning and Troubleshooting Transactional Replication - Kendal Van Dyke

At some point in every DBA's career, they are probably asked to work with transactional replication. But most DBAs don't look under the covers after they've walked through the setup wizards. Even worse, when something breaks, you don't know where to look and end up trying to figure out what's wrong and how to fix it. In this session, we take a deeper look at setting up, monitoring, and calibrating transactional replication. We also share troubleshooting tricks and tips gleaned from years of experience working with high-volume, multiple-datacenter topologies.

[atchimule]

how do find which table transactions are pending delivery to the subscriber .. we have seen transaction replication latencies with log reader agent ..can you plz explore more about the log reader agent troubleshooting

[ashutoshmishra]

I am using SQL Serve Enterprise Edition (64-bit) and in this i am using transactional-replication with on Publisher, one Replication Distribution Agent with four Subscriber. everything was going smoothly but now when i am seeing my replication in SQL server through replication monitor and clicking on 'subscription watch list' all subscribers status are showing as 'Expiring soon/Expired' and i am not sure why and when i am double clicking on subscriber error message are 'no replicated transactions are available'.please suggest me what to do