INF: sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage (274376)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q274376

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).
Modification Type:MajorLast Reviewed:10/15/2002
Keywords:kbBug kbDSupport kbinfo KB274376
©2002 Microsoft Corporation. All rights reserved.