Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Replication Performance

Author  Topic  beanz Starting Member 35 Posts Posted - 2003-05-12 : 03:11:46 Morning Everyone! This is my first post so I'll apologise in advance if this question has been answered elsewhere! I have two sites, London and Lymm, at each site is a SQL 2K server replicating a CRM database via Transactional replication. Next week this database goes live but the replication performance is terrible. For example, inserting a new customer record takes between 5 and 10 seconds! I had thought about changing the replication type/interval but would this lead to data inconsitencies? The data needs to be as current as possible at both sites. Any advice greatly appreciated! Danny