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.

Published 07 July 2010 12:33 by simonsabin

Comments

# Twitter Trackbacks for Network compression and database mirroring - Simons SQL Blog [sqlblogcasts.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 Network compression and database mirroring - Simons SQL Blog         [sqlblogcasts.com]        on Topsy.com

08 July 2010 11:14 by Sanjeev Agarwal

# Daily tech links for .net and related technologies - June 8-10, 2010

Daily tech links for .net and related technologies - June 8-10, 2010 Web Development How WebMatrix, Razor