Navigating SQL Replication SubscriptionStreams setting
Navigating SQL Replication SubscriptionStreams setting Rishi Maini Microsoft SQL Escalation Services This blog posting discusses the new Distribution Agent SubscriptionStreams parameter. This option reduces the latency when moving data from Distributor to Subscriber by using multiple parallel writer threads. For more information on Replication “threads” see Transactional Replication Conversations blog posting. From SQL Books Online (good place to start) -SubscriptionStreams [0|1|2|...64] Is the number of connections allowed per Distribution Agent to apply batches of changes in parallel to a Subscriber, while maintaining many of the transactional characteristics present when using a single thread. For a SQL Server Publisher, a range of values from 1 to 64 is supported.
See more here:
Navigating SQL Replication SubscriptionStreams setting
