INF: sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage

Article translations Article translations
Article ID: 274376 - View products that this article applies to.
This article was previously published under Q274376
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SUMMARY

The sp_mergecleanupmetadata system stored procedure introduced in Microsoft SQL Server 7.0 Service Pack 2 (SP2), allows administrators to clean up meta data in the MSmerge_contents and MSmerge_tombstone system tables to improve merge performance and save space by reducing the size of those tables at Publishers and Subscribers.

In case of large MSmerge_contents and MSmerge_tombstone tables, sp_mergecleanupmetadata requires a large amount of log space and time. This behavior is because all the deletions from both tables need to be recorded in the transaction log.

MORE INFORMATION

The sp_mregcleanupmetadata stored procedure has been optimized to improve performance in Microsoft SQL Server version 7.0 Service Pack 3 (SP3).

Properties

Article ID: 274376 - Last Review: October 21, 2013 - Revision: 1.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbinfo kbpending KB274376

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com