Microsoft KB Archive/274376

= INF: sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage =

Article ID: 274376

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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).

Keywords: kbinfo kbbug kbpending KB274376

-

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

© Microsoft Corporation. All rights reserved.