Page History
TCP Buffer UsageTDS Packet 1TDS Packet 2TDS Packet NSQL Traffic AcceleratorTDS Packets 1 thru N4KWaste15-20 Packets in as little as 8KNative TDS ProtocolSQL Traffic Idera SQL Traffic Accelerator sits between SQL Server and its clients and turns the normally inefficient SQL Server TDS protocol into a tight, highly compressed, and optimized protocol. The following illustration image shows the native TDS protocol versus the SQL Traffic Accelerator protocol. Not only is bandwidth and performance improved through compression, but the TCP/IP protocol is also more efficiently used by turning TDS into a variable length protocol. Whereas the native protocol would transfer one packet of 4096 bytes into a single TCP buffer, SQL Traffic Accelerator packs 15 or more packets into a single buffer. It is not uncommon for a 4K packet to be reduced to a mere 300 or 400 bytes. Because SQL Traffic Accelerator is specifically developed to optimize the TDS protocol, it has a far greater impact on bandwidth and performance than hardware compression technologies. Additionally, SQL Traffic Accelerator uses adaptive compression technology that automatically detects when uncompressible data is encountered, so SQL Traffic Accelerator never has a negative impact on performance.
This compression and optimization takes low-speed WAN connections and makes them perform nearly on par with 100 BASE-T connections, and 100 BASE-T connections perform on par with 1000 BASE-T connections or better. Additionally, SQL Traffic Accelerator can be used to free up bandwidth on congested networks, regardless of speed.
