O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required