Microsoft KB Archive/255688

= FIX: Static Filtered Merge Publications Take Long Time to Synchronize =

Article ID: 255688

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q255688



BUG #: 56831 (SQLBUG_70)



SYMPTOMS
Prior to SQL Server 7.0 Service Pack 2 (SP2), creating the snapshot files in Merge Replication for publications, by using the static filters, might take a considerable amount of time depending on the data modification activity on the table(s) included in the articles, regardless of the filter criteria specified.

The Snapshot files include a BCP data file for the MSMerge_contents table. This fix applies the filter criterion to the contents of the MSMerge_contents table, reducing the size of the BCP file significantly, depending on the contents of the table and the filter conditions. In many cases, this vastly improves performance of the initial snapshot. Also, if you are using JOIN filters, appropriate indexes on the JOIN columns also help considerably to improve performance.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

Additional query words: snapshot filter Merge replication

Keywords: kbbug kbfix KB255688

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.