I set up a Transactional Replication on 2 Standard 2008 SQLSERVERs on LAN
- one was publisher and also distributor
- another one was the subscriber
All options are default.
My SQL Replication has worked normally for 5 days until yesterday. Periodically, i checked the data on subscriber manually, there are no update for subscriber for 12 hours.
I tried to View Synchronization Status and also Replication Monitor.
Everything seem fine excepting the below status didn't change for a long time.
"View Synchronization Status : Delivering Replicated Transaction"
I tried to test the latency of distributor and subscriber by inserting a Tracer in Tracer Tokens of Replication Monitor. The latency of "Publisher to distributor" was 00:00:01, but the latency of "Distributor to Subscriber " and "Total
latency" were "Pending". It still was "Pending" after 30 minutes.
-The biggest transaction of my system just updated 35.000 records/time. It's not big enough to stuck the replication.
-There is no trigger on the subscriber.
1.Any suggestions so far ? Thanks
2.The status is "Delivering Replicated Transactions" . So, where to see the current transactions that have been delivering by Distributor ? The one that caused system stuck. Not all. The highest one in agent queue
View Complete Post