Hi again,

Something strange though, just with this new database's replication:

instance A (active):
database    replicated transactions    replication rate trans/sec    replication latency (sec)
mydatabase <------------>  9 <------------>  125 <------------>   0.016
myNEWdatabase <------------>    0  <------------>    0.1059547 <------------>     10.073

Hi guys,

UPDATE:
We created a new database, publisher and suscription; replicated it successfully from A to B (different web hosting providers).
The other publishers/subscriptions are working as usual.

It worked correctly, we inserted...

Hi all,

Steve, maybe you misread my readings?
I'm going through the article you kindly posted and it seems we are okay about this specific topic, replication latency is...

2016 and 2017 tables are different only in the name

A results:
database    replicated transactions    replication rate trans/sec    replication latency (sec)    replbeginlsn    replnextlsn
mydatabase    8    6125    0.046    0x0016E38C00037DCC0001    0x0016E38C00038B040003

B results (why does it have replicated...

I'll answer both of you here:

"Didn't you say that the 2016 and 2017 tables were both going over A-B but 2016 performed well but 2017 did not?"
Indeed,...

"It sounds first like the Latency Warning parameters are set as the default, which will definitely give the warnings such as you are describing over the internet connection."
That's right,...

both tables are exactly the same in constraints, keys, indexes, no triggers, etc.
the only difference is that one has been replicated for almost a year, and the new one...

"What is the latency and bandwidth capability between A and B?"
I'll ask our server hosting providers.

"The last time it worked was it set up EXACTLY like it...

Hi, it has happened again.

Do you think it can be caused by query notifications?

anybody?

a colleague told me this had happened before, more than 18 months ago

so weird