Replication Slow at Subscriber Due to Missing Indexes
By Lori Brown | Helpful Scripts , Indexes , Replication , SQL Server
Problem Have you ever had transactional replication mysteriously start showing significant latency at a subscriber server? If so, check to see if the primary keys from the publisher database are missing on the subscriber database! Replication was showing long latency while the publisher and subscriber servers were not heavily utilized. Microsoft generated stored procedures that […]
Continue reading