Network compression and database mirroring
Interesting to read this blog by Mark Blakey about database mirroring network performance http://sqlblogcasts.com/blogs/blakmk/archive/2010/04/30/optimising-database-mirroring-over-wan.aspx
He found that he could reduce network traffic by 75% by turning off encryption. This is understandable because you can’t compress encrypted data, there aren’t any patterns of data to encrypt. Its why if you want encrypted compressed backups you still have to go to 3rd parties like Redgate and Quest. Thats because to do it in SQL you have to encrypt the data first which means the built in backup compression in SQL Server can’t get any compression.