SQL Server Performance

transaction replication on high speed network

Discussion in 'SQL Server 2005 Replication' started by masqazi, Jul 9, 2007.

  1. masqazi New Member

    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.
  2. satya Moderator

    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.
  3. MohammedU New Member

    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.

Share This Page