Our load is 1million+ transactions a day...
"Hilary Cotter" wrote:
> 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 >
>
>
> "BATMAN" <BATMAN@discussions.microsoft.com> wrote in message
> news:14FDB883-2651-469C-A006-A2324656DDA7@microsoft.com...
> > So we are using a remote distributor with a few subscibers, 4 to be
> > exact...
> > So should we use push subscriptions?
> >
> > Thanks Hilary!
> >
> > "Hilary Cotter" wrote:
> >
> >> 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 > >>
> >> "BATMAN" <BATMAN@discussions.microsoft.com> wrote in message
> >> news:E6E6ABEE-7C4D-434E-A6D5-015B7892BD90@microsoft.com...
> >> >I know it is recommended for topologies with many subscibers... We have
> >> >only
> >> > a few, few reporting servers...
> >> >
> >> > "BATMAN" wrote:
> >> >
> >> >> 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.
> >> >>
> >> >> Thanks!
> >>
> >>
> >>
>
>