|
gangadhara.ms
Constraint Violating Yak Guru
India
497 Posts |
 Posted - 08/30/2012 : 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
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
Posted - 08/30/2012 : 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. |
 |
|
Replication latency
