I have setup a pull transactional replications which replicates every 24 hrs.
Tables I am replicating has heavy transaction activity, like we make atleast
100 thousand transactions on those tables.
When distributor agnt tries to run on schedule every day morning at 2:00 am
, it just keeps on running thru out the day...is there option i can check so
that it replicates faster..?
have a look at replicating the execution of stored procedures.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:F7C0361D-3B8D-4D06-AB03-A214BA8F7217@.microsoft.com...
> I have setup a pull transactional replications which replicates every 24
hrs.
> Tables I am replicating has heavy transaction activity, like we make
atleast
> 100 thousand transactions on those tables.
> When distributor agnt tries to run on schedule every day morning at 2:00
am
> , it just keeps on running thru out the day...is there option i can check
so
> that it replicates faster..?
Thursday, March 8, 2012
24hrs Transactional Tables
Labels:
24hrs,
activity,
database,
heavy,
hrs,
microsoft,
mysql,
oracle,
pull,
replicates,
replicating,
replications,
server,
setup,
sql,
tables,
transaction,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment