Re: Database Replication

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ryan,

I've been using transactional replication at my current employer for years
and latency will always be determined by geographic region and equipment.
In my case I'm seeing less than 5 second latency, usually lower than 2, and
yes, of course you can run queries on the data that is being replicated.

Resources are minimal once replication is setup, during the initial
snapshot, the only issues you might run into are the locking of the tables
as they are processed for replication.

Adam P. Cassidy


"Ryan" <Ryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D4AA35E2-CBA7-4052-93AB-37DF213D729D@xxxxxxxxxxxxxxxx
Paul, thanks a lot!

Do you know any limitation on using transactional replication? eg the min
delay time, can it perform query during the replication.

Aslo how's the overhead on resources of compare to mirroring? Is it
require
many resources (eg. CPU and RAM) during the processing?

Regards,
Ryan


"Paul Ibison" wrote:

Ryan,
transactional replication is often used for this type of reporting
requirement. You could also enhance the system by using the snapshot
committed isolation levels to maintain access while the distribution
agent
is running. The main 'competitor' technology on SQL Server 2005 is
database
mirroring with database snapshots. There's no detailed list of pros and
cons, but as I'm a replication guy I'll point out that mirroring doesn't
support FTI and you can't take back ups of snapshots :)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .





.

Relevant Pages

  • Snapshot for transactional replication
    ... I am implementing transactional replication which I tested with a selection ... tables imports some of the data from the snapshot folder and after a long ... to connect to the subscriber it then goes into "the process is running and is ...
    (microsoft.public.sqlserver.replication)
  • Re: Synchronising In-House and Web Data
    ... Since transactional replication is transaction based, ... Director of Text Mining and Database Strategy ... The CSV files we send to the web-server are in the ...
    (microsoft.public.sqlserver.replication)
  • Re: Concurrent
    ... I think you mean transactional replication rather than "concurrent ... transactional replication the snapshot is generated by holding brief locks ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Architecture/Design advise
    ... bi-directional transactional replication to be ... publisher goes offline for an extended time period. ... > Does this mean that the standby server can update the primary? ...
    (microsoft.public.sqlserver.replication)
  • Re: Help in setting up SQL Server 2005 Replication
    ... The reason i wanted to chose transactional replication with updatable ... active database as it is a push/pull situation. ... bi-directional transactional replication may be a better fit. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)