patternsqlMinor
Can I make my distribution database use In-Memory OLTP?
Viewed 0 times
canmakedatabaseoltpmemorydistributionuse
Problem
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?
Have you tried it?
Did that increase the overall performance when the distribution database was the bottleneck for your replication?
Solution
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.
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.
Context
StackExchange Database Administrators Q#125557, answer score: 3
Revisions (0)
No revisions yet.