Replication issue Publisher to Distributor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Replication issue Publisher to Distributor

Replication issue Publisher to Distributor

Rate Topic

Display Mode

Topic Options

Author

Message

selvamanip-657233

Posted Monday, February 16, 2009 7:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 05, 2009 9:12 PM
Points: 1, Visits: 7

We have configured transactional replication between our Databases running in two different SQL servers. But the publisher and distributor is running in same SQL server where the slowness is noticed. Publisher is getting queued up around 30000+ records and distributor is receiving it very slowly. please let us know what could be the problem.

Post #657726

Kendal Van Dyke

Posted Monday, February 16, 2009 8:52 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 10:23 AM
Points: 361, Visits: 781

Not very much information provided, so I'll talk in some generalities...if your server is acting as both the publisher and the distributor you are likely to run into IO contention issues. When a write occurs on your published database it's recorded in the transaction log. The log reader agent (an out of process executable) then needs to read the log and write each transaction that applies to replication to the distribution database. The distribution agent (another out of process executable) reads it from the distribution database and sends the change to the subscriber. Meanwhile more writes are taking place back in your published database. It's pretty clear to see how this can cause your system to slow down, especially as the volume of data that changes on the published database gets larger.

Best practices dictate that (especially for high volume replication) you use a separate, dedicated distributor.

Kendal Van Dyke
http://kendalvandyke.blogspot.com/

Post #657819

« Prev Topic | Next Topic »

Permissions