Hello,
I can't find information on the internet. Is there any limit on number of subscriber with Push réplication ?
I have 100 client with SQL server Express edition. with this edition only the push réplication is available.
Thanks
asked
SQL Server 2019 Push réplication, Any limit on number of subscriber
Express can only be a subscriber, so just to confirm you have a full SQL Enterprise/Standard server being the publisher & distributor?
The bottleneck then comes on the network and if these express subscribers will be down for excessive periods of time.
By default if a subscriber is down for more than 3 days it needs to be reinitalised as all the transactions will be forced removed from the distribution DB.
Replicating to over 100 subs can then slow down the publisher as it’s having to push each update out to the subs, so you need to think about performance of the log reader, distribution agents etc.
There is no published limit as it is all environment specific as to how many you can handle.
How I have seen large subscribers done before is to create dedicated distributor for the publisher, then have a sub/pub/dist in each point of presence then have each server in the PoP subscribe to the local PoP publisher.
Primary Publisher -> Dedicated Primary Distributior -> Point of Presence Subscriber with Publisher and Distribution -> Local Subscribers.
That way the load on the primary publishers network is reduced as it’s only pushing to 1 or 2 machines not all subscribers across the WAN.
15 People are following this question.
