SQL Server Enterprise 2016, Is compatibility level 130 "REQUIRED" for Memory Optimized Tables?

Copper Contributor

We are running SQL Server Enterprise 2016 compatibility level 100 for customer reasons.  We want to employ "Memory Optimized Tables" with this customer.  The documentation "suggests" using compatibility level 130 as a minimum.  However, we have found NO documentation stating this is a minimum requirement.  We have done extensive testing with Compatibility 100 and have found no issues.  So, the question:

 

For SQL Server Enterprise 2016, Is compatibility level 130 "REQUIRED" for Memory Optimized Tables?  

0 Replies