replication latency issues | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

replication latency issues

In pre-production environment….(brand new servers) I have setup sql server 2005 transactioanl replication for a database. – Publisher database(only have one) is in Ottawa, Canada
– Distribitor database(only have one) is in Ottawa, Canada
– 2 Subscriber databases are in Ottawa, Canada
– 2 Subscriber databases are in Toronto, Canada
(Ottawa to Toronto is about 400km away) The pipe in Ottawa 1GBit
The pipe from Ottawa to Toronto is 50MBit The latency seen for Ottawa Distributor to Ottawa Subscribers is 5 secs.
The latency seen for Ottawa Distributor to Toronto Subscribers is 40 mins. what can i do to make the 40 mins be ALOT better?

Take help of PERFMON (SYSMON) counters for these two processes are the SQL Server Replication LogReader: Delivery Latency counter and the SQL Server Replication Dist.: Delivery Latency counter. http://technet.microsoft.com/en-us/library/ms151762(SQL.90).aspx
http://technet.microsoft.com/en-us/library/ms152522.aspx
.. should get you more information on what you can make it better. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Take a look to the following article…it is for 2000 but works for 2005 also.. http://msdn2.microsoft.com/en-us/library/aa902656(SQL.80).aspx Following is good reading…
http://www.sql-server-performance.com/replication_tuning.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

]]>