Optimizing performance of MSSQL Merge Replication

July 28, 2018 0 By Narendra Jha

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')

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