SQL 2016 – It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms


Moved from: bobsql.com

 

SQL Server 2016 introduces two distinct changes in the AlwaysOn transport, compression design.
 

Improved compression algorithms Parallel compression of log block data 

Compression can be performed faster, using less resource overhead and maintains compression ratios.

 

SQL Server 2016 also introduces parallel compression operations.  The following chart outlines the performance and resource gains as tested using a TPCC stress load.

 

 

Throughput MB/s

Average CPU utilization (secondary)

MB sent on wire/sec

Today

82

17

35

2016