SQL Server Performance Forum – Threads Archive

transaction replication on high speed network

Is there anyway we cant adjust the replication speed according to network capacity, like speedy replication with big data packets for fast networks and replication with smaller data packets for slow networks. where and how we can setup this.

I don’t think such option is available within SQL Server. Most important factors you need to consider on performance basis are: Server and network hardware, Database design, Distributor configuration, Publication design and options, Snapshot options & database maintenance. After replication is configured, it is recommend that you develop a performance baseline, which allows you to determine how replication behaves with a workload that is typical for your applications and topology. Latency and throughput are most relevant to transactional replication, because systems built on transactional replication generally require low latency and high throughput. So having available resources with high-spec such as memory & disks would help a lot to attain the performance for high-end subsystem. 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.

Take a look to the following article which will give you some info and it should also applies to 2005… Transactional Replication Performance Tuning and Optimization
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>