Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Transactional replication performance tuning and optimization (white paper)
Article ID: 323046 - View products that this article applies to.
This article was previously published under Q323046
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.aspxIncluded in this document: