Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

High replication latency Expand / Collapse
Author
Message
Posted Thursday, December 19, 2013 10:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 1,225, Visits: 7,747
I'm seeing higher than normal latency in our transactional replication and it seems that all the log readers are sitting with wait types of Repl_Schema_Access...much more so than what we've seen in the past. I've tried to do some research on this wait type, but I've not had much luck yet. Is there anyone familiar with this? Any thoughts on what it might be pointing towards as a holdup?

Thank you,
Josh
Post #1524705
Posted Friday, December 20, 2013 2:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 3:50 AM
Points: 49, Visits: 335
Hi,

What is your setup of the replication
How many publisher
How many subscriber do you use
Did you use a distributor-server, or is the distributor on one of the publishers?
Do you use PUSH or PULL subscriptions?

I had high latency, because i used only one distribution database for many publications.

kind regards,

andreas

Post #1524897
Posted Friday, December 20, 2013 8:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 1,225, Visits: 7,747
I've got 7 publishers sending to 2 different subscribers. There is a combination of push and pull subscriptions running. The distributor itself is a separate server. Currently the latency we see is only on the log reader....distributor to subscriber seems to run well.

Josh
Post #1525012
Posted Friday, December 20, 2013 8:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 3:50 AM
Points: 49, Visits: 335
Hi,

have you tested the latency with the "insert token" in the replication monitor?

Post #1525017
Posted Friday, December 20, 2013 8:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 1,225, Visits: 7,747
Haven't used tokens. I've been checking numbers using sp_replcounters on the publisher and using fn_dblog as well. I've also used the DMV's on the distributor, but it seems to see log reader latency differently than the sp_replcounters does. We tend to be able to tie in latency of the log pretty accurately using fn_dblog and that matches up with the latency seconds in sp_replcounters.
Post #1525031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse