question

ZArloul avatar image
ZArloul asked

SQL Server 2019 Push réplication, Any limit on number of subscriber

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

transactional-replication
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.