SQL Server Performance

Each Article will have Pull Subscription

Discussion in 'Performance Tuning for SQL Server Replication' started by Jon M, May 13, 2005.

  1. Jon M Member

    Hi,
    Assuming I have 40 articles, is it advisable to have each article being published to have its own subscription (in this case 40 subscriptions)? The reason for doing this is I would like to perform my snapshot on selected articles only during production hour.

    Thanks,
    Jon M
  2. satya Moderator

    If you want to perform the operation selectively then go by creating a dedicated subscription for each article, otherwise no reason for it.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page