SQL Server Performance

performance without subscription

Discussion in 'Performance Tuning for SQL Server Replication' started by boutwater, Oct 17, 2003.

  1. boutwater Member

    Hi, I recently removed all the subscriptions that I had for a transactional publication. I left the publication on. The reason that I did this was to increase performance for the time being. It doesn't seem to have worked. The log reader is still marking transaction, and I still see some slow responses. Anyone have any ideas? Thanks for your help,

  2. satya Moderator

  3. Twan New Member

    As Satya hinted, the removal of subscribes won't help performance of the publisher... It may help performance for the distributer (since there is nothing to actually distribute) hence there seems to be little point in keeping the publication without having any subscribers


Share This Page