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

sp_replcmds very slow Expand / Collapse
Author
Message
Posted Saturday, December 21, 2013 11:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 12:27 AM
Points: 1, Visits: 23
Publisher --> SQL 2008 R2 Enterprise Edition

Distributor--> SQL 2008 R2 Enterprise

Transaction Repl Log Reader very slow, executing sp_replcmds against pub.
Not much data seen loading into distributor

6 minutes latency seen on for all distribution agents and climbing...

Publisher is under High Seasonal Load.

Where to find bottleneck as the log reader sp_replcommands is an extended sp and cannot open.

12/23/2013 update: We also increased the read batch size to 500 and then up to 1500 with no improvemtne.

Thanks in advance!!
Post #1525284
Posted Saturday, December 21, 2013 4:27 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:32 AM
Points: 809, Visits: 1,157
I would suggest you to go through the below mentioned article. This is is the one of the best article to troubleshoot the replication performance issues.

http://blogs.msdn.com/b/chrissk/archive/2009/05/25/transactional-replication-conversations.aspx
Post #1525301
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse