Optimizing performance of Merge Replication

The three system tables created as a part of Merge replication that should be reindexed on a regular interval

1) MSmerge_contents

2) MSmerge_genhistory

3) MSmerge_tombstone

The below command should be used to reindex these tables. (Weekly scheduling of these commands through a SQL job is recommended)

DBCC DBREINDEX ('MSmerge_contents')

DBCC DBREINDEX ('MSmerge_genhistory')

DBCC DBREINDEX ('MSmerge_tombstone')

==========================================

Leave a Reply

Your email address will not be published. Required fields are marked *