Optimising Database Mirroring over WAN

Posted by blakmk on SQL Blogcasts See other posts from SQL Blogcasts or by blakmk
Published on Fri, 30 Apr 2010 11:12:00 GMT Indexed on 2010/04/30 11:38 UTC
Read the original article Hit count: 352

 

I recently got asked by our network guys about botlenecks in the WAN that used for mirroring to our DR I site. They asked me to turn off encryption of Database Mirroring so that the riverbed software  they were using could optimise the packets sent over the WAN.

I was a bit sceptical at first about the security risks, but it seems the riverbed software has its own form of obfuscation making the packets difficult to read.

After reading an article by rusanu I realised that it could be done with minimal downtime and potential reducing network traffic by 5-10% on its own.

After turning off encryption I was pleasantly suprised to see that overall network traffic for mirroring dropped by a whopping 75%!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This Web Page Created with PageBreeze Free HTML Editor

© SQL Blogcasts or respective owner

Related posts about Database mirroring sql se