Can Distribution Database Use In-Memory OLTP in SQL Server?

replicationsql serversql server 2014

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

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.