so, do you suggest us to limit memory, and redirect traffic back to the primary database instance (currently we are running on the secondary instance) and see if it doesn't...

for clarification: 3 SQL server instances = I meant 3 different database servers, not the same database server
all of them have the same exact configuration

2 of them...

Btw, all 3 instances are configured to use uo all memory.

Do you think this is an issue?

nevermind, we were restoring the database with keep_replication setting
unchecking it solved everything

Sorry, the subject is confusing.
We want to know what is going on, and also if you think our replication topology is correct?

All 3 DB servers are distsributors,...

hi guys,

replication continues to work correctly on the new db
i guess we'll never know what happened, maybe we reached a limit and that's why it started to...

Hello,

"we'll switch the load from the activedb to the newdb on that table only and see how it works"
We did this yesterday and it worked. Very odd...

<ignore>