SQL Server Performance

replication latency issues

Discussion in 'SQL Server 2005 Replication' started by bfarr23, Jun 20, 2007.

  1. bfarr23 New Member

    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?


  2. satya Moderator

    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.
  3. MohammedU New Member

Share This Page