Can I make my distribution database use In-Memory OLTP? Is it possible to have all the distribution tables use In-Memory OLTP (formerly known as Hekaton) for enhancing performance of the distribution database?

Have you tried it?

Did that increase the overall performance when the distribution database was the bottleneck for your replication?
Is it possible to have all the distribution tables use In-Memory OLTP (formerly known as Hekaton) for enhancing performance of the distribution database?


This is a good question and made me thinking. But .... the answer is NO as of SQL Server 2016 CTP 3.0.

The documentation says :


  Replication tables on the distributor cannot be configured as memory-optimized tables.