WAN compression option - by Mark Guinness

Status : 


Sign in
to vote
ID 377479 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 10/23/2008 4:22:38 PM
Access Restriction Public


It would be a useful option to provide the ability to compress data on the fly for client connections, in a similar fashion to the encrypt option when you connect to a database.  For example, from the client application you could connect with:

Data Source=sqlserver;Initial Catalog=master;Integrated Security=SSPI;Compress=yes

It would be a great ability for remote offices connecting into a central database server over a slow WAN connection and would result in cost savings for small businesses.  Larger businesses would probably use dedicated hardware like PacketShaper (http://www.bluecoat.com/products/packetshaper/specifications).
Sign in to post a comment.
Posted by Mark Guinness on 5/9/2011 at 7:07 PM
With the advent of SQL Azure, the ability to compress the TDS protocol would be even more desirable since external connections would be made over a relatively slow internet connection.
Posted by MatthewAdams on 11/3/2010 at 12:40 PM
Your suggestion of using Windows Server 2008 assumes control over the client's operating system, which you may not always have. Baking this feature directly into SQL Server and the SQL Server provider for ADO.NET would be much preferred.

By the way, this issue duplicates the following suggestion:

Combining them would result in more votes.
Posted by Microsoft on 10/31/2008 at 9:51 AM
Thank you for the interesting suggestion. We will take this feedback into consideration in a future SQL release.

In the meantime, I recommend you trying SQL Server 2008 running on Windows Server 2008, with the client preferably running on Windows Server 2008 as well. SQL Server 2008 takes advantage of TCP enhancements in Windows Server 2008 specifically targeted at large data transfers over WAN networks. Our testing showed significant reduction in transfer times.

You can learn more about TCP enhancements in Windows Server 2008 at http://technet.microsoft.com/en-us/library/bb726965.aspx.

Thank you.