Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Improving Replication scalability at multiple sites


In a distributed environment, whether it is intranet or internet based, it is crucial to keep the data flow autonomous and available online when needed. The transaction is atomic and a certain level of scalability is needed as the load against the database increases. In any case, the application is dependent on more reads than writes, for such scenarios it is a compulsory requirement to scale out the 'read' processes of the workload by caching read-only data across the multiple database and instances where the web server connectivity is directed. If the databases are geographically dispersed, then it is highly essential to scale out the data flow between the sites to support read and write requests for scalability and improve availability.

In this recipe, we will go through the common requirements for replication, scalability, and provide appropriate solutions with the type of replication to use.

Getting ready

The prerequisite for this process...