Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / August 2008

Tip: Looking for answers? Try searching our database.

troubleshooting Transactional Replication Latency

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fernando - 23 Aug 2008 17:16 GMT
Hi everybody.

SERVER_A: Windows 2003 Server with SQL Server 2005 SP2. This is the
corporative server for all our data. About 30 tables divided in 4
publications. Each publication contains the tables belongs at the same
database. This is the suscriber of one publication I describe below.

SERVER_B: Windows 2003 Server with SQL Server 2005 SP2. This is the
suscriber of the 4 publications and have one publication of 4 tables. This
server is the distributor too.

SERVER_A and SERVER_B are connected to a LAN (100MB) at same switch.

Latency measured by Replication Monitor in the Publications of SERVER_A are
excelent (2 or 3 seconds). In the other side, latency in the publication of
SERVER_B are bad, critical or fatal (30 seconds, 1 minute or more).

I don't know how to measure the changes that we have in the tables belongs
to publications in SERVER_A but I remenber that this are the tables of our
corporative environment and I presume that they are so much.

Changes in publications of SERVER_B are in order of 100.000 rows in 120
seconds (I know it well because this server runs a process created by myself).

How it's possible that both servers sharing the same network the latency are
so different?

How can I decrease this latency?

Thanks a lot.
Paul Ibison - 23 Aug 2008 18:06 GMT
I'm not too sure from the description - are the number of changes made on
the 2 servers the same? Have a look at the size of the msrepl_commands table
on eash server (or run sp_browsereplcmds) to get a feel for the commands
waiting to be replicated.
HTH,
Paul Ibison (www.replicationanswers.com)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.