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.
| 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 MSSQL 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. |
 |
|
|
|
|
|
Replication latency