July 17, 2013 at 3:27 pm
Hello,
We have sql 2005 and running Replication fro m3ed party s Publication and we have subscription.
Sometimes performance is too slow for our other user and we have to kill those users which ones are waiting.
The DB runs for suvscription is almost above 200 GB.
Thanks.
January 8, 2014 at 7:08 pm
I'd suggest looking at the replication metadata retention period on the publisher. It defaults to 14 days, but if for some reason you have it as unlimited, the metadata tables start getting increasingly big and it can affect performance, publisher and subscriber. Other than that, just the standard performance things - SQL related like rebuilding indexes, using a full recovery model and having an enormous transaction log file (I see this in so many client envs where they think "oh full must be better than simple so I'll chose that", without setting up proper maintenance plans). And even physical issues like HDD fragmentation, memory.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply