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

Dean Marchetti 5 Reputation points
2023-11-28T16:22:45.0433333+00:00

We are running SQL Server Enterprise 2016 compatibility level 100 for customer reasons and cannot upgrade at this time or any time soon.  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?  

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,270 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 106K Reputation points MVP
    2023-11-28T22:04:33.0866667+00:00

    Do you have a link to this particular piece of documentation?

    I'm tempted to say that if it works, it works. But I still like to see what the documentation actually says.