all groups > sql server replication > october 2006 >
You're in the

sql server replication

group:

push or pull - SQL 2000 Transactional


push or pull - SQL 2000 Transactional BATMAN
10/27/2006 3:50:01 PM
sql server replication: I just talked to Microsoft and I was told to do push subscriptions instead of
pull, to run the distribution agents on the distributor. I have come across
different resources that say otherwise... What is the best approach with a
distributed topology.

RE: push or pull - SQL 2000 Transactional BATMAN
10/27/2006 4:56:01 PM
I know it is recommended for topologies with many subscibers... We have only
a few, few reporting servers...

[quoted text, click to view]
Re: push or pull - SQL 2000 Transactional Hilary Cotter
10/27/2006 8:01:09 PM
For high load you should use a remote distributor. For large numbers of
subscribers use pull. I am not sure why they have made these recommendations
but they were probably not made lightly.

--
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

[quoted text, click to view]

Re: push or pull - SQL 2000 Transactional BATMAN
10/27/2006 8:16:02 PM
So we are using a remote distributor with a few subscibers, 4 to be exact...
So should we use push subscriptions?

Thanks Hilary!

[quoted text, click to view]
Re: push or pull - SQL 2000 Transactional Hilary Cotter
10/28/2006 12:00:00 AM
What sort of load will you be experiencing? Do you know how much CPU your
load will create on your server? If it is substantial go to remote
immediately, if not you can use a local distributor. For this small number
of subscribers I would always use push, unless they are frequently
disconnected.

If you are using a remote distributor you must make sure it is clustered,
otherwise you are asking for trouble as you have a single point of failure.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



[quoted text, click to view]

Re: push or pull - SQL 2000 Transactional BATMAN
10/28/2006 10:54:02 AM
Our load is 1million+ transactions a day...

We do currently have a clustered remote distributor...

And we have 4 subscribers (server subscribers) that will never be
disconnected, unless of outage.

So with that said, is push the best way to go and why?

Thanks!

Michael


[quoted text, click to view]
AddThis Social Bookmark Button