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?
Best Answer
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 :