SQL Server Performance

Standby distributor

Discussion in 'Performance Tuning for SQL Server Replication' started by siva_pothireddy, Sep 5, 2003.

  1. siva_pothireddy New Member

    Hi,

    I'm trying to implement transaction based replication. What would be the best
    strategy to protect the distributor from the outages?

    Thanks.

    Siva
  2. satya Moderator

    One of the advantage of transactional replication is that the distributor holds the transactions until the subscriber prcoess in push mode. In pull mode, I guess the distributor holds the transactions for a specified length of time before deleting them.

    One of the article referred :
    I would go with a "two-phase commit" approach to disaster recovery is that it will significantly reduce performance, and not accomplish what you want.

    If your applications are going to require that a transaction only be committed if two servers
    are up and running.


    In general for the DR recently refer to Kalen's articlehttp://www.sqlmag.com/Articles/Index.cfm?ArticleID=39647 where most of the topic is covered to handle.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page