Fill factor on subscriber
Hello,
We have an OLTP application for which a majority of the database's tables are replicated between two environments.
The publisher side is intended to handle the writes from users and the subscriber handles the reporting aspect of the application.
The subscriber therefore is mainly read by users and should only be updated by replication.
Should I alter the fill factor on the subscriber's indexes to be higher percentage than the publisher or should they be the same as the publisher?
Regards,
SCM.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 6, 2009 4:17 PM
UPDATED:
February 6, 2009 4:31 PM
RELATED QUESTIONS
- Resolving all losing conflicts-Merge Replication in SQL Server 2005 and 2000
- Moving Distribution database from an instance to antother does increase performance ?
- Transactional Replication: Publisher & Subscriber size mismatch
- Replication sync_method set to concurrent in SQL Server 2000
- Filter SQL Replication Deletes by user
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
