SQL 2016 – It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches


Moved from: bobsql.com

 

The AlwaysOn log transport uses a SQL Broker based design to send and receive messages between the primary and secondary replicas.    Studying the transport behavior revealed various improvement opportunities.

 

Many of you have read the various materials indicating that log transportation between the primary and secondary is commonly 1/3 that of file copy speed.   That is no longer the case.  A SQL Server 2016 AlwaysOn database can commonly maintain 90% or better transitional throughput rate directly comparing the same workload against a standalone database.

 

For example, SQL Server 2014 requires ~16, thread context switches to transport a