Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication - Slow performance Expand / Collapse
Posted Wednesday, July 17, 2013 3:27 PM


Group: General Forum Members
Last Login: Monday, December 1, 2014 9:05 PM
Points: 184, Visits: 653

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.

Post #1474816
Posted Wednesday, January 8, 2014 7:08 PM


Group: General Forum Members
Last Login: Wednesday, May 14, 2014 6:39 PM
Points: 21, Visits: 93
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.
Post #1529186
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse