Transactional replication performance tuning and optimization (white paper) (323046)

SUMMARY

Transactional replication is a type of replication that SQL Server 2000 provides that permits data modifications to be propagated incrementally between servers in a distributed environment. You can use transactional replication for many different applications, from reporting servers and data warehousing environments to Web servers and e-commerce applications. Transactional replication is used at many of the predominant Web sites on the Internet that run SQL Server, including MSN.com, Passport.com, BarnesandNoble.com, and Buy.com.

Transactional replication is a scalable and reliable solution for distributing data in high-performance environments. This paper examines performance in transactional replication and demonstrates ways in which you can improve the performance of your applications. This paper is based on the results of tests that were conducted by using a variety of hardware configurations and replication environments. Based on the test results, recommendations are made in areas such as applying the initial snapshot, optimizing replication settings, and replication scalability.

To access this paper, visit the following Microsoft Web site: Included in this document:

• Improving Replication Performance
• Improving the Performance of Transactional Replication
• Improving Performance in Applying the Initial Snapshot
• Transactional Replication Performance Examples