<div>
First article is just what i need,. I need to plan it in for out of hours which should be this weekend so if its ok i wil leave question open until Monday<br />
<br />
Thx for your help<br />
<br />
Jay
</div>


First article is just what i need,. I need to plan it in for out of hours which should be this weekend so if its ok i wil leave question open until Monday

Thx for your help

Jay

<div>
Worked like a charm. New subscription set used to take 14 hours now takes 58 minutes so ill mark that a success :)<br />
<br />
Thx<br />
<br />
Jay
</div>


Worked like a charm. New subscription set used to take 14 hours now takes 58 minutes so ill mark that a success :)

Thx

Jay

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Using merge replciation single distributor/publisher running lots of articles. B it confused though and still quite new to replication.<br />
<br />
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.<br />
<br />
I need to know why the data is now being purged, sys.sp_mergemetadataretent<wbr />ioncleanup<wbr /> appers to be firing after each merge, idera is reporting long CPU times pretty regularly but the table keeps growing.<br />
<br />
Please advise as not sure how to proceed<br />
<br />
Jay
</div>
</div>


Hi,

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

Jay

Merge Replication subscription expiration

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.