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 2005 Forums
 SQL Server Administration (2005)
 Replication latency

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-08-30 : 02:50:35
Hi Experts,

We have a Transactional replication between the 2 servers which are geographically distributed (one server is in Sydney) and another one is in US.

The End user expecting the delay of upto 2 to 3 minutes,we want to reduce this latency.
What are all the way are possible.?

Thanks,
Gangadhara MS
SQL Developer and DBA

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-08-30 : 05:36:01
Good bandwidth and reduce the amount of data transferred.
In particular remove unnecessary updates - only update if the value is changed, don't insert then update, do multiple updates on a single row in a single statement, don't update a whole large table - or if you do see if you can transfer it by snapshot rather than transactions.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -