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: 376
Database mirroring sql se
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