Microsoft KB Archive/323046

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

Article ID: 323046

Article Last Modified on 6/9/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q323046



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://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx

Included in this document:
 * Improving Replication Performance
 * Improving the Performance of Transactional Replication
 * Improving Performance in Applying the Initial Snapshot
 * Transactional Replication Performance Examples

Keywords: kbinfo kbwhitepaper KB323046

-

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

© Microsoft Corporation. All rights reserved.