previous post, Hilary replied that the size of MSmerge_Contents doesn't really matter, but index fragmentation does. However, referring to
BOL, it says, "Additionally, you should minimize the size of the merge system tables (specifically MSmerge_history) by using
sp_mergecleanupmetadata." Is it still necessary to do that in SQL Server 2005?
Also, when running select metadatacleanuptime
from sysmergesubscriptions, I found that the cleanup time is just about a week before. However, my merge interval is only 5 minutes, and I remembered during last week I did a manual sp_mergemetadataretentioncleanup although
paused in half way. How to check the clean up interval?
Last but not least, I have already did index rebuild on MSmerge_Contents, MSmerge_henhistory, and MSmerge_tombstone, and found that the average fragmentation dropped from above 90% (MSmerge_Contents) to below 1%, but the overall performance did not improve
obviously. I remembered when merge replication was set up at the begining, th
View Complete Post