| Event Id | 27183 | | Source | MSSQL_REPL | | Description | The merge process failed to enumerate changes in articles with parameterized row filters. If this failure continues, increase the query timeout for this process, reduce the retention period for the publication, and improve indexes on published tables. | | Event Information | According to Microsoft
Cause:
This error is raised if a Merge Agent timeout occurs while processing changes in a filtered publication. The timeout might be caused by one of the following issues:
1.Not using the precomputed partitions optimization.
2.Index fragmentation on columns used for filtering.
3.Large merge metadata tables, such as MSmerge_tombstone, MSmerge_contents, and MSmerge_genhistory.
4.Filtered tables that are not joined on a unique key and join filters that involve a large number of tables.
Resolution:
To resolve the issue:
1.Increase the value of the -QueryTimeOut parameter for the Merge Agent to allow processing to continue while you address the underlying issues causing the error. Agent parameters can be specified in agent profiles and on the command line. For more information, see:
a.How to: Work with Replication Agent Profiles (SQL Server Management Studio)
b.How to: View and Modify Replication Agent Command Prompt Parameters (SQL Server Management Studio)
c.How to: Work with Replication Agent Profiles (Replication Transact-SQL Programming)
d.Programming Replication Agent Executables.
2.Use the precomputed partitions optimization if possible. This optimization is used by default if a number of publication requirements are met. For more information about these requirements, see Optimizing Parameterized Filter Performance with Precomputed Partitions. If the publication does not meet these requirements, consider redesigning the publication.
3.Specify the lowest setting possible for the publication retention period, because replication cannot clean up metadata in the publication and subscription databases until the retention period is reached. For more information, see Subscription Expiration and Deactivation.
4.As part of maintenance for merge replication, occasionally check the grow | | Reference Links | Event ID 27183 of Source MSSQL_REPL |
|
|
