For more information about how to measure the latency of a transactional replication, visit the following Microsoft Developer Network (MSDN) Web site:
For more information about the performance effects of virtual log files, visit the following MSDN Web site:
- Add a transaction log file to the publication database. The transaction log file should meet the following requirements:
- The initial size is large.
- The value of the Autogrowth property is large.
- Use the DBCC SHRINKFILE statement to reduce the size of the transaction log files that contain many virtual log files. For more information, click the following article number to view the article in the Microsoft Knowledge Base:907511 How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005
Article ID: 949523 - Last Review: Mar 8, 2010 - Revision: 1