Eric Barro
ebarro at afsweb.com
Fri Oct 31 10:54:18 CST 2003
Mark, How are you actually moving the data? Are you having replication transfer the changes via FTP? I would recommend this approach. Basically the replication process delivers the file (containing the data to be replicated) to a folder on the publisher/distributor machine and then the subscriber picks up the file via FTP and runs replication after it grabs the file. --- Eric Barro Senior Systems Analyst Advanced Field Services (208) 772-7060 http://www.afsweb.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Mark Boyd Sent: Friday, October 31, 2003 6:13 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Issues with Multiple Subscriptions Eric - Yes, replication is running off a WAN link. The Distributor is in my office, along with 1 other SQL Server. The other 2 servers are about 200 miles away. >> Those log agents and snapshot agents will kill your processor and lop off expensive CPU cycles. What other options do I have? Thanks, Mark -----Original Message----- From: Eric Barro [mailto:ebarro at afsweb.com] Sent: Thursday, October 30, 2003 6:07 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Issues with Multiple Subscriptions Mark, M$ replication is such a resource hog. Those log agents and snapshot agents will kill your processor and lop off expensive CPU cycles. Are you running replication over a WAN link? --- Eric Barro Senior Systems Analyst Advanced Field Services (208) 772-7060 http://www.afsweb.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Mark Boyd Sent: Thursday, October 30, 2003 12:51 PM To: SQLServerList Subject: [dba-SQLServer]Issues with Multiple Subscriptions I am in the process of creating 3 Push Subscriptions from 1 Distributor/Publisher. Basically, I need all 4 SQL Servers to have the same data replicated between each other. Are there any known issues with setting up all 3 Replication Schedules to run at the same times during the day? I want to have the data replicated every 15 minutes, between 5:00AM and 11:00PM. Is there a problem with each push having the same start time, or should I have each start about 5 minutes after each other? Are there any other issues I should consider? TIA, Mark Boyd Sr. Systems Analyst McBee Associates, Inc. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003