In SQL Server replication, pull subscriptions acquire the replicated data from the publishing server using periodic updates, initiated by the subscribing server. When pull subscriptions are used, each subscribing server can specify the preferred update time. Pull subscriptions are mainly used for replicating data to many subscribers, or for load balancing of a heavily loaded network.
Pulses in the Foglight for SQL Server home page move in the direction of dataflows. As the rate of data transfer increases, so too does the speed of the pulse. Pulses can change color when the statistic represented by the pulse moves to another threshold.
In SQL Server replication, push subscriptions require the publishing server to push any changes made to the data out to the subscribers. Push subscriptions are mainly used when data needs to be replicated in near real time.
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center