[dba-SQLServer]Issues with Multiple Subscriptions

Mark Boyd MarkBoyd at McBeeAssociates.com
Fri Oct 31 08:12:58 CST 2003


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




More information about the dba-SQLServer mailing list