April 2, 2020 at 7:05 pm
Hi
We get a DB that is replicated every 10 seconds or so
We are having an speed issue running SP's against this database. Does anyone know of a command that I could temporary turn off Replication while the SP runs then turn it back on after the SP is completed?
Thanks
April 2, 2020 at 8:12 pm
As long as it's for a brief period of time, Disable the replication agent jobs. Then re-enable them when you are done. And you may want to leave the cleanup job disabled until the transactions are all replicated.
I saw your earlier post - you may want to be open to the issue being anything, not just replication. Look at execution plans, wait stats and checking basics on the instance using things such as Glenn Berry's diagnostic queries. If you focus all your efforts on this being replication and it has nothing to do with replication, you won't solve the issues. Things like this can end up being other things - something like bad statistics which are often overlooked. Replication won't typically cause the problems you are describing.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply