|
Reducing Network Bandwidth when Replicating Microsoft SQL Server
If you're running a Microsoft SQL Server database and are concerned that your bandwidth usage may be higher than it should be, try excluding the temporary database (TEMPDB.MDF) from the replication set.
As you probably know, Double-Take only transmits data across the network when information is written to the disk. When a user reads information out of the database, one might think that this would not create a write, and therefore would not generate traffic across the network. However, Microsoft SQL Server responds to a query by first writing the results to a table in the temporary database. Over the course of many small queries (or a few large ones), a significant amount of unnecessary replication traffic may be generated.
To avoid this, simply exclude the temporary database from the replication set. This is completely safe because in a failover or other recovery situation, Microsoft SQL Server does not use any data contained in TEMPDB. This is a simple and safe way to reduce the amount of replication traffic without losing any ability to recover data on the targets. By the way, most other relational database systems work the same way, so this solution applies to them, too!
|