Merge Replication subscription expiration
Posted on 2011-09-08
Using merge replciation single distributor/publisher running lots of articles. B it confused though and still quite new to replication.
the publication expiration is set to 1 month, however the msmerge_gen history has data in it ( alot) going back to mid april circa 4 months? This is now up to over 20 mil rows and so performance is unsurpisngly poor.
I need to know why the data is now being purged, sys.sp_mergemetadataretentioncleanup appers to be firing after each merge, idera is reporting long CPU times pretty regularly but the table keeps growing.
Please advise as not sure how to proceed