SqlServer durable memory-optimized tables can boost SqlTransport performance

[mauroservienti]

The current tables design of the SqlTransport is sub-optimal and should be redesigned. Starting Sql Server 2014 memory-optimized tables are supported, meaning a table exists only in memory and, if configured as durable, all operations are stored in the T-Log (they can be backed up or shipped to another server) that is much faster, being append only, than a regular table.

Using durable memory-optimized tables could greatly improve SqlTransport performance.

Possible plan

• Spike the usage of durable memory-optimized tables to verify that the current transport requirements are met and investigate potential drawbacks
• Verify the performance improvement impact
• Implement support for durable memory-optimized tables in the transport