Transactional replication performance tuning and optimization (white paper)

Article translations Article translations
Article ID: 323046 - View products that this article applies to.
This article was previously published under Q323046
Expand all | Collapse all

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:
http://technet.microsoft.com/en-us/library/cc966539.aspx
Included in this document:
  • Improving Replication Performance
  • Improving the Performance of Transactional Replication
  • Improving Performance in Applying the Initial Snapshot
  • Transactional Replication Performance Examples

Properties

Article ID: 323046 - Last Review: June 9, 2004 - Revision: 5.3
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbinfo kbwhitepaper KB323046

Give Feedback

 

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